Hi, I am very new to excel and was wondering if you could explain to me how to do the following:

I have a work book containing 2 sheets, on page 1 I have a drop down box and on page 2 I have a list of names and adresses.
I have linked the names on page 2 to the drop down box on page 1, I now want to populate a cell on page 1 with the adress that is in a seperate column but in the same row as the name on page 2.

Could you please help!

Regards
Adrian

---

Answer from Richard Rost:

You can use the VLOOKUP function for this. Once you get the value in your drop-down box, reference the cell that it's linked to for the VLOOKUP. That will return the address or other information. See this tutorial for help:

You can use the VLOOKUP or HLOOKUP function.

VLOOKUP is a powerful function in Microsoft Excel that allows you to look up a value from another spreadsheet - or a smaller subtable (lookup table).

See this FREE tutorial for help with VLOOKUP:

http://599cd.com/tips/excel/vlookup/?key=BlFAlEx