How to use “Lookup” command in Microsoft Excel?

Published October 10, 2010

Question by ranga238: How to use “Lookup” command in Microsoft Excel?
I have two Excel Files. One contain Names of employees, the other file contains name and employee numbers. I need to update the employee numbers from one file to another. There are more than 20000 lines. Manually this would be a big task to refer one file and update the other.

I know there is a “Lookup” command which is available. By using that we can update automatically. Unable to use this command. Can any one help me with the exact command and how to do this.

Thanks.

Best answer:

Answer by doug a
=VLOOKUP(A1,Sheet1!$ A$ 1:$ B$ 7,2,FALSE)

A1 = the thing you want to look up

Sheet1!$ A$ 1:$ B$ 7 = the look up table that’s in sheet 1

2 = is the column to bring back from that look up table

plonk that in the the 1st free column

need any more help let me know

http://www.data-technology.co.uk/Support

What do you think? Answer below!