Match to 3 criteria the return results

**JennOlsen** · 04-30-2021, 12:32 PM

Good Morning!

I have a spreadsheet with two tabs. I would like a formula that matches to Last name, then to Last 3 SSN, then to Unit #. If there is a match to all three between the two tabs, I would like the email address from tab 2 to populate in the email column on tab 1. I'm pretty good when it's just one, multiple criteria confuses me!

**Bo_Ry** · 04-30-2021, 12:48 PM

Please try

=XLOOKUP(1,(Table13[Last Name]=C2)*(-Table13[Last 3 SSN]=-E2)*(-Table13[Unit]=-D2),Table13[Email],"")

or
=IFNA(INDEX(Table13[Email],MATCH(1,(Table13[Last Name]=C2)*(-Table13[Last 3 SSN]=-E2)*(-Table13[Unit]=-D2),)),"")

**JennOlsen** · 04-30-2021, 12:59 PM

Seems to be working perfectly!! Thank you!!

Match to 3 criteria the return results

LinkBack

Thread Tools

Rate This Thread

Display

Match to 3 criteria the return results

Re: Match to 3 criteria the return results

Re: Match to 3 criteria the return results

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Array Formula: Match Multiple Criteria, Return Many Results

[SOLVED] Array Formula: Match Multiple Criteria, Return Many Results

[SOLVED] match two criteria check if they match another criteria then return result. Query vlookup

[SOLVED] Lookup to match multiple criteria and return multiple results excluding duplicates.

return all results that match two criteria EXACT

Index and match formula, attempting to return results with multiple criteria.

Bookmarks

Bookmarks

Posting Permissions