Finding a Match

[MikeyZ]

On one sheet1 my array (B2:C500 has a P/N in column A.

On another sheet2 I have an array B2:C3000 with P/N's in Col "A" as well.

In the cells in Col "A" I want to be able to look at the P/N in sheet1 in Col "B", find a match on sheet2 , and if Col "C" has data in the cell, I want to just show a "Y" in the adjacent cell "A".

Any idea what formula I should use. I've exhausted my talents.

Mike

 

[JamesW]

Hi there,

Not sure if this is what you want, but try:

=IF(VLOOKUP(A2,Sheet2!$A$1:$C$3000,3,FALSE)=0,"N","Y")

This will lookup the value in A2 (sheet1) from the table A1:C3000 in Sheet2 and check if there is a value in column C. If there is put a Y, if not put an N.

 

[MikeyZ]

Sweetttt