VLOOKUP using dropdown list for table array

**mpquin** · 10-27-2009, 04:54 PM

I would like to creat some sort of formula similar to a VLOOKUP where a cell reference to a dropdown list can be used to alter the location of where to cross reference.

I have multiple name defined ranges in a dropdown which would be used for the table array part of the formula. However, I only get errors with the current formula. Hope this makes sense. I have attached an example that might help.

Thanks,
Mike

**NBVC** · 10-27-2009, 04:57 PM

Try:

=VLOOKUP(C4,INDIRECT(B4),2,0)

**Big_Tater** · 05-20-2010, 12:30 PM

Originally Posted by NBVC

Try:

=VLOOKUP(C4,INDIRECT(B4),2,0)

This was EXTREMELY helpful NBVC. Thank you guru's for all you do to help us beginners out.

**Declamatory** · 11-05-2014, 09:38 AM

Hi, The above has helped me but the dropdowns I am using are on a form that people will sign. Using the above formulas means that the dropdown people select would have to be written in the array format. So say for example I had postage charges based on where people live. People selected their county, state or whatever in the dropdown the charges would appear. I don't want people to have to see IsleofMan as an option. I would like them to be able to select 'Isle of Man' i.e. with spaces between words.

Is there anyway that I can use the above formula but make B4 look pretty when selecting the dropdown? In the example spreadsheet above the option would be week1 on the dropdown whereas I would like people to be able to select Week 1 (with a space).

Any help you could give me would be greatly appreciated.

Thanks

Dec