Adress in excell

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:15 PM GMT

Question

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.


Answer

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:

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

Advertisement

©2017 eLuminary LLC. All rights reserved.