Match or Vlookup Help Please

[Joe Gieder]

I have two worksheets, one (WS1) has only part numbers
but in two columns, one is called part number & the other
is Alt P/N, the other WS (WS2) has a lot of other
information including part number. What I'm trying to do
is use the part number in WS2 (column J)and look in WS1
to see if the part number exists in either the part
number (Col A) or Alt P/N coulmn (Col B). If the part
exists I want column G to say "Yes" and if it doesn't
have it say "No"
The formula I'm using is:
=IF(MATCH(J4,'MSP Listing'!A5:B1559,0)="","No","Yes")

Please help and Thank You
Joe

 

[Bob Phillips]

Joe,

This is the format

=IF(NOT(ISNA(MATCH(J4,'[wbname.xls]MSP LIsting!A5:B1559,0))),"Yes","No")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Ken Wright]

One way:-

=IF(NOT(ISNA(VLOOKUP(B3,WS1!$A$1:$A$100,1))),"Yes",IF(ISNA(VLOOKUP(B3,WS1!$B$1:$
B$100,1)),"No","Yes"))

 

[Ken Wright]

Scratch that, forgot the 4th arg of false:-

=IF(NOT(ISNA(VLOOKUP(B3,WS1!$A$2:$A$23,1,0))),"Yes",IF(ISNA(VLOOKUP(B3,WS1!$B$2:
$B$23,1,0)),"No","Yes"))

or another way

=CHOOSE(3-ISNA(MATCH(B3,WS1!$A$3:$A$23,0))-ISNA(MATCH(B3,WS1!$B$3:$B$23,0)),"No"
,"Yes","Yes")