Excel Help
Author
Discussion

silver.fox.2008

Original Poster:

820 posts

221 months

Tuesday 18th August 2009
quotequote all
Any excel wizards that can help?

I've got a spreadsheet with 2 columns, lets say ID number and address.

On another workbook i need to just input the ID and it automatically populate the cell next to it.

Does anyone know the formula for this? VLOOKUP?

Mx_Stu

837 posts

254 months

Tuesday 18th August 2009
quotequote all
I've only done vlookups once or twice.

Google should be your friend, plenty of excel guides out there (straight forward ones aswell)

Ultuous

2,291 posts

222 months

Tuesday 18th August 2009
quotequote all
Vlookup should do it:

- Highlight the range containing the data you want to 'look up' (ID and name columns)
- Click in the box showing the cell name (just under the toolbar, before the sheet itself)
- Type in a name for the range ([yourrangename])
- Move to your other sheet
- in B1 (assuming your ID to look up is in A1) type '=vlookup(a1,[yourrangename],2)
- Copy down your list

Hope that makes sense!

Edited by Ultuous on Tuesday 18th August 10:42

Ultuous

2,291 posts

222 months

Tuesday 18th August 2009
quotequote all
Ooops.. missed the bit about doing it across seperate workbooks... Don't bother naming the range (i.e. ignore steps 1-3 above) - in the vlookup formula, just replace [yourrangename] with the range reference you require (easiest way of doing this is to navigate back to your source workbook whilst entering the formula, and highlight the range using the mouse! smile)

Edited by Ultuous on Tuesday 18th August 10:37

mrmr96

13,736 posts

235 months

Tuesday 18th August 2009
quotequote all
Yeah, vlookup is the right function to use. If you don't understand the explaination above (which while correct requires a knowlege of termininology) do a google search for how to use vlookup and there's loads of guides and examples.

For example
http://www.timeatlas.com/mos/5_Minute_Tips/General...

silver.fox.2008

Original Poster:

820 posts

221 months

Tuesday 18th August 2009
quotequote all
Cheers guys smile