LookUp

[thepartydj]

I have a list of part numbers on sheet 1 column B
I also have another list of part numbers on sheet 2 column B
I want to do the following
If a part number on sheet 1 matches a part number on sheet 2, simply put an X in sheet 1 column J

All I know is I need to put a lookup formula of some kind in every cell of Column J on sheet 1

Thanks for your help!

 

[AlanY]

Re: Easy Look Up Help

one way

=IF(ISERROR(VLOOKUP(B1,Sheet1!B:B,1,0)),"","X")

 

[Scott T]

Re: Easy Look Up Help

Try, change ranges to match your data.

=IF(ISNUMBER(MATCH(B2,Sheet2!$B$2:$B$9,0)),"X","")

 

[Nine Zero]

Re: Easy Look Up Help

try this out

=IF(COUNTIF(Sheet2!$B:$B,Sheet1!$B1)>0,"X","")

 

[JackDanIce]

Re: Easy Look Up Help

Try:

=REPT("x",--ISNUMBER(MATCH($F1,$B$1:$B$10,0)))