Discussion
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!
- 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
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!
)
)Edited by Ultuous on Tuesday 18th August 10:37
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...
For example
http://www.timeatlas.com/mos/5_Minute_Tips/General...
Gassing Station | Business | Top of Page | What's New | My Stuff


