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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Collapsing all groups 0
Matching !! 4
Index and Match 8
Creating a dynamic IF statement 2
if function (if more that 7 nesting) 2
adding figures that match 2 true and 1 false if statement conditio 5
sumif error 4
if or match hmmmmmm 3

Back
Top