Matching text

  • Thread starter Thread starter Judith
  • Start date Start date
J

Judith

Hi all

My problem is a bit similar to Paige's from a couple of
days ago.
On sheet one in column A I have 300 statements, in col B I
have a code number for the statement.
On sheet two in col A I have another 50 statements.
I need to know, for each statement on sheet two, if there
is a match to any of the statements on sheet one and if so
what is the code number beside the statement on sheet one.

What is the formula???

Cheers
 
Assuming that you do this from sheet2

=IF(ISNUMBER(MATCH(A2,Sheet1!$A$2:$A$310,0)),VLOOKUP(A2,Sheet1!$A$2:$B$310,2
,0),"No Match")

copy down 50 rows, adapt to fit your ranges accordingly
 
Back
Top