IF and Vlookup Statement

Jack Nguyen

I'm not sure if should I do it right

What I would like to achieve:

Smartsheet A - with list of the application name and ID

Smartsheet B - will collect information from Smartsheet A

 

I use if statement below and give me error # INVALID OPERATION

=IF({import Info Range 1}="PDI", VLOOKUP([Primary Column]@row, {import Info Range 2}, 3, true))

thx!

Paul Newcome

I would suggest something more along the lines of...

=INDEX(COLLECT({Other Sheet Column To Pull From}, {Other Sheet Station Column}, "PDI", {Other Sheet Column4}, [Primary Column]@row), 1)

Jack Nguyen

=INDEX(COLLECT({import Info Range 4}, {import Info Range 1}, "PDI", {import Info Range 5}, [Primary Column]@row), 1)

and I got error '# invalid Column Value '

Paul Newcome

I would suggest something more along the lines of...

=INDEX(COLLECT({Other Sheet Column To Pull From}, {Other Sheet Station Column}, "PDI", {Other Sheet Column4}, [Primary Column]@row), 1)

Jack Nguyen

=INDEX(COLLECT({import Info Range 4}, {import Info Range 1}, "PDI", {import Info Range 5}, [Primary Column]@row), 1)

and I got error '# invalid Column Value '

Paul Newcome

Make sure the column types on both sheets match.