Return Name correspond to Id

[Guest]

In sheet 1, I have:
A B
1 ID Name
2 101 Smith
3 102 John
4 104 Pat
4 201 Linda
6 256 Jane

In sheet 2, I have:
A B
1 ID Name
2 102
3 104
4 256

I need formula in sheet2: B2,B3,B4 to return something like this:
A B
1 ID Name
2 102 John
3 104 Pat
4 256 Jane

Thanks in advance.

 

[Ron de Bruin]

Hi plumstone

See the Excel help for the VLookup function

 

[crispbd]

in cell B2 of sheet2 enter the following formula:

=VLOOKUP(B2, Sheet1!$A$2:$A$10000, 2, False)

then fill the formula down the B column.


*10000 should be the number of total rows in sheet 1 where there is
name and I