Nested If with Vlookup

Ashley Styers

If statement with Vlookup as the true value.

I have a sheet that is doing a vlookup from one column but if one criteria is met, then I need it to vlookup a second list.

I'm using this for the main vlookup: =VLOOKUP([L2]@row, {POC}, 2, false)

and if Last, First is the name in L2, then I need it to look at L3 and retrun that value. Is this possible?

=VLOOKUP([L3]@row, {POC}, 2, false)

This is what I'm working with but doesn't work.

=IF(L2, = "Last, First", then (VLOOKUP([L3]@row, {POC}, 2, false)) VLOOKUP([L2]@row, {POC}, 2, false))

Thank you!!

Terri Leong

It looks like your syntax might just be off. Try "=IF([L2]@row = "Last, First", VLOOKUP([L3]@row, {POC}, 2, false), VLOOKUP([L2]@row, {POC}, 2, false))"

Terri Leong

It looks like your syntax might just be off. Try "=IF([L2]@row = "Last, First", VLOOKUP([L3]@row, {POC}, 2, false), VLOOKUP([L2]@row, {POC}, 2, false))"

Ashley Styers

Thank you so much Terri!!! That worked!