Need to find and replace

[Guest]

I have two Sheets. I have a list of numbers in FIRST sheet and another list
in the SECOND sheet. But in the second sheet there is another column with
another information.
What i want to do is that Excel could find the value of the first sheet in
the second sheet and could write that data next to the list of values in the
first sheet.

Here how it shoud look:

Sheet1
Column A | Column B
25
35
40
50

Sheet2
Column A | Column B
30 | 1.5
31 | 2.1
40 | 3.1
25 | 4

I WANT:

Sheet1
Column A | Column B
25 | 4
35 | NO DATA
40 | 3.1
50 | NO DATA

 

[Barb Reinhardt]

The VLOOKUP function will do much of what you want.

 

[Ragdyer]

Try this in B1 of Sheet1:

=IF(ISNA(MATCH(A1,Sheet2!$A$1:$A$4,0)),"No
Data",VLOOKUP(A1,Sheet2!$A$1:$B$4,2,0))

And copy down to B4.