Forum Discussion
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 Nam...
=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.
