Match or Vlookup Help Please

J

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
 
B

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)
 
K

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"))
 
K

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")
 
Top