Alright guys I have been using Vlookup for a minute and I have a question
I need to knowhow to make V lookup look for 2 Lookup_Value example below
if A & B on sheet 1 are the same as A & B on sheet 2 copy C from Sheet 2
TIA
![]()
Alright guys I have been using Vlookup for a minute and I have a question
I need to knowhow to make V lookup look for 2 Lookup_Value example below
if A & B on sheet 1 are the same as A & B on sheet 2 copy C from Sheet 2
TIA
![]()
Use INDEX/MATCH instead
=INDEX(Sheet2!C:C,MATCH(1,INDEX((Sheet2!A:A=A1)*(Sheet2!B:B=B1),0),0))
Avoid using full column references though and adjust based on your range
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks