The VLOOKUP function will do much of what you want.

"Vytautas" wrote in message
...
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