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...
Slightly modified
=INDEX($J$4:$J$9, MATCH(1, INDEX( ($C4=$H$4:$H$9) + ($C4=$I$4:$I$9), 0), 0 ) )(no CSE)
Sp. THANKS FOR UOLOADING DEMO FILE. LOVED THIS SOLUTION. WORKED LIKE A CHARM FOR ME. BEAUTY IS I COULD CHANGE THE RANGE OF INPUT DATA AFTER COPY/PASTE IN ANY EXCEL FILE & WORK ON IT.