Nested If with Vlookup

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!!

Find more posts tagged with

Accepted answers

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))"

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.