Excel issue [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!