Multiple Criteria In Vlookup

[Dazzawm]

Hi. I know how to do Vlookup (using the wizard) when only having to look at one column. How do you or is it possible to look at more than one? For example I have 2 sheets and I need a result from one column by looking to see if the criteria is the same in 4 other columns first.

So I need columns B, D, E, & F on sheet 1 to look at the same columns on sheet 2 and if the data matches put what is in column C on sheet 2 into column C on sheet 1. Understand!!?? Thanks.

 

[Dazzawm]

Let's try out the concatenation approach...


In U2 enter and copy down:

=H2&"|"&I2&"|"&M2&"|"&O2&"|"&P2&"|"&Q2&"|"&R2


In C2 on Sheet1 just enter and copy down:


=INDEX(Sheet2!$C$2:$C$30001,MATCH(H2&"|"&I2&"|"&M2&"|"&O2&"|"&P2&"|"&Q2&"|"&R2,Sheet2!$U$2:$U$30001,0))

Eureka!! Its worked! Thanks for your time and patience.

 

[Aladin Akyurek]

Eureka!! Its worked! Thanks for your time and patience.

Great. Thanks for providing feedback.