I am very new toand 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.
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 Microsoftthat allows you to look up a value from another spreadsheet - or a smaller subtable (lookup table).
See this FREE tutorial for help with VLOOKUP: