VLookup with 2 different criteria

Hi everyone,

I am trying to figure out if there is an OR function that would work, or another way to look for only 1 of 2 values for a Vlookup. I have a cute little formula that helps me know if people signed off on a project - (the completion page looks up on the form results for an email and a date, and reports back to with a Vlookup formula - and when the cell is no longer blank, it turns my indicator green.) This works great for everyone but one stinker, who has 2 emails and alternates between them.

This is my original formula

=IFERROR(VLOOKUP([Email at _____]@row, {Training Sheet Range 1}, 2, false), " ")

I tried a few variations, but I keep getting errors. Any suggestions?

Find more posts tagged with

Accepted answers

All comments

SoS | Dan Palenchar

Hello @Rsparks

I see you're using an IFERROR(), if this is because you are getting a #NO MATCH in this case you can add a second INDEX(MATCH()) as your 'value if false' that is formulated in a way to get the other value. This is what I have done for situations where I am trying to pull in 2 options. The first INDEX(MATCH()) looks for the first option and if it errors out the second kicks in.

👨🏼‍💻 Dan Palenchar | School of Sheets Solutions Consulting (Smartsheet Aligned Gold Partner)

If this response helped you please help me & the community by accepting it and reacting as you see fit (💡insightful, ⬆️ Vote Up, and/or ❤️Awesome).

🆘 Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus

▶️ Smartsheet Tutorial Videos: schoolofsheets.com/youtube

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.