VLOOKUP multiple values

Copper Contributor

VLOOKUP multiple values

Hello!

I am working on a spreadsheet containing our clients information to upload into a new CRM. The spreadsheet has multiple tabs.  Each tab has a separate row for the clients First Name, Last Name & Client ID.  There is one master tab containing all of the information but the other tabs only have the clients First and Last name. I need to match each Client ID from the master tab to the correct names on the other tabs.

I am hoping that VLOOKUP (or some excel function) can help me with this.  Thank you so much for your help!!

2 Replies

Re: VLOOKUP multiple values

``=VLOOKUP(F5&G5,CHOOSE({1,2},\$A\$5:\$A\$21&\$B\$5:\$B\$21,\$C\$5:\$C\$21),2,0)``

You can try this VLOOKUP formula.

``=INDEX(\$C\$5:\$C\$21,MATCH(1,(\$A\$5:\$A\$21=F5)*(\$B\$5:\$B\$21=G5),0))``

An alternative could be INDEX and MATCH.

The formulas have to be entered with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.

Re: VLOOKUP multiple values

Thank you!

I will try this now and let you know.  I appreciate your help!