Previous Topic Next Topic

Excel issue

Closed
Kalyan - Dec 16, 2009 at 10:25 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 17, 2009 at 06:20 AM
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 ?
Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 17, 2009 at 06:20 AM
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
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response