2 vlookups

[nqueen]

Hi,

I have two sheets. I want to do 2 vlookups or anything similar from 1 sheet to the other.

ex:

if sheet1.colA and sheet1.colE = sheet2.colA and sheet2.colD
do something (both need to be true in order to do something)
else
don t do anything

I know I could add a column in both sheets and do a concatenation and then make a vlookup on that column but I was wondering if there was a way to do it in 2 different cells without having to add a column?

 

[walla07]

Hi nqueen,

You could try a combination of the MATCH and AND functions. If you wanted to look up the data on sheet 1 to see if it was on sheet 2, =IF(AND(MATCH(A1,Sheet2!A:A,1),MATCH(E1,Sheet2!D,1)),"YES","NO"), then copy this formula into all the rows on Sheet 1.

Hope this if of use.