Drop-Down List

**ramblinpaul** · 03-31-2007, 08:04 PM

I'm using drop-downs to choose from a list of location names.

When a location is selected I would like to have cells below the drop-down to display the locations corresponding address which is stored/displayed in 6 or 7 cells.

What do I need to do?

I hope that make sense. Does anyone have an answer/suggestion to my question?

Thanks!

Paul

**VBA Noob** · 04-01-2007, 04:32 AM

Hi,

Maybe a vlookup

http://www.contextures.com/xlFunctions02.html

VBA Noob

**ramblinpaul** · 04-03-2007, 08:05 PM

Originally Posted by VBA Noob

Hi,

Maybe a vlookup

http://www.contextures.com/xlFunctions02.html

VBA Noob

I can't get a VLOOKUP to do it, either. It will only display 1 cell of the table (address), not the entire range which stores the full address.

**Leith Ross** · 04-03-2007, 10:24 PM

Hello Ramblinpaul,

Could you post a brief worksheet or code description of what you want to do ? It would help to better understand your needs.

Sincerely,
Leith Ross

**Paul** · 04-03-2007, 10:49 PM

Depends on what exactly you're trying to do, but consider this:

If your drop-down is in cell A1 and it is linked to cell A1, you can reference that value in one VLOOKUP going down the column to get the rest of the columns from your data sheet. For example:

A1 = your dropdown list
In A2 through as many rows as there are columns in your data lookup sheet, use the formula:

=VLOOKUP($A$1,Sheet2!$A$1:$F$10,ROW(),FALSE)

This will lookup the value in A1, match it against your data lookup range, then return the column from that range that matches the row your formula is in. Might not make sense the way I'm explaining it, but it does return multiple values from one value in the drop-down cell.

**BigBas** · 04-03-2007, 11:06 PM

I opted for an HLOOKUP function, because I assumed the data would be stored with a location name, and the corresponding addresses underneath.

I used this formula in cell A2:A10 (obviously your range will vary)

=IF(ISERROR(HLOOKUP(A$1,Locations!$A$1:$H$6,ROW(),FALSE)),"",HLOOKUP(A$1,Locations!$A$1:$H$6,ROW(),FALSE))

Drop-Down List

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Drop-Down List

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions