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

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

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"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