Matching text

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
 
P

Peo Sjoblom

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

Using the IF and Sheets 0
adding multiple values from matched search results 3
Creating a dynamic IF statement 2
Match issue 3
Index and Match 8
IF statement not returning correct answer 3
Multiple IF Statement in Word 5
adding figures that match 2 true and 1 false if statement conditio 5

Top