Excel issue

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hi,
I have 2 excel sheets and would like to look at one sheet; compare the contents of a cell with another excel file and if it corresponds, i want to pick the corresponding value from a different column from this sheet and put it in the original sheet.
Is this possible.
Here is an example.

Sheet 1
Extension Name
5001
5002
5058
5863
5904
5974


Sheet 2
Extension Name
5001 SPARE
5002 HOLIAN L
5003 DAVENPORT M
5004 BERRY A
5009 SCHUSTER D
5010 ALEXANDER S

I want the names to be populated on the first sheet by looking up the numbers in the second sheet.
Can anyone please help with this ?

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
in sheet1 in B2 copy paste this formula

=VLOOKUP(A2,Sheet2!$A$1:$B$100,2,FALSE)

copy B2 down.

note the dollar signs in the formula.


vlookup function is an useful function.read help on this function ine excel help