Forum Discussion
Vlookup to multiple columns
Hello! I was wondering if there was a formula to do a vlookup referencing 2 different columns? In the below example I have 2 tabs of data; on tab 1 I want to do a vlookup based off of column C h...
You can use INDEX/MATCH, like this:
=INDEX($I$4:$I$9,MATCH(C4,$G$4:$G$9&$H$4:$H$9,0),)
Or XLOOKUP:
=XLOOKUP(C4,$G$4:$G$9&$H$4:$H$9,$I$4:$I$9)