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...
=INDEX($I$4:$I$9,MATCH(1,MMULT(1*(C4=$G$4:$H$9),ROW($1:$2)^0),0))=VLOOKUP(C4,CHOOSE({1,2},$G$4:$G$9&$H$4:$H$9,$I$4:$I$9),2,0)An alternative could be INDEX / MATCH or VLOOKUP. Enter either formula with ctrl+shift+enter if you don't work with Office365 or 2021.