Match or Vlookup Help Please

  • Thread starter Thread starter Joe Gieder
  • Start date Start date
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
 
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)
 
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"))
 
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")
 
Back
Top