If Statement with VLookup

AmandaC

Hello! Hoping that someone can help! I am trying to do an IF statement with a VLookup from another smartsheet, not even sure if this is possible. This is what I have so far but I keep getting an error.

=IF(@row), VLOOKUP({Master Roster Range 2}, {Master Roster Range 1}, 3)

I am wanting to say, "If @row is a certain value" then lookup value in reference sheet column and pull from corresponding column.

Jess Bowles

What are your ranges including? For vlookups, you have to include your "key" value as the first column of both ranges so that it will match them. You may have more success using a match/index function.

Based off your formula- that looks very possible. If you include here what your ranges are it might help more.