MS Excel Drop Down issues

mono-brow · 10-15-2008, 09:41 AM

Hi,

Could somebody please provide assistence for linking data for a drop down menu on Excel. I can put normal listings in a single colum but i want to be able to pull down say A1 and that the data contained in B1 only appears when one of the ranges in A1 is clicked.

Ie.

A1 = types of door
B1 = Sizes
C1 = Prices

I have looked on the net and it seems confusing.

THanks in advance

sphinxheaven · 10-15-2008, 12:49 PM

Hey,
Thinking that we need more clarification towards this issue, however from reading i get the idea that you just might need a simple "IF" formula for Column B & C.........
Please provide more information so we can asses the issue more in depth. A spreadsheet example would be perfect, use the Go Advance feature to attached a Zipped xls to us.

mono-brow · 10-17-2008, 05:45 AM

Hi,

I have attached the file - it is a working document now.

As discussed before I want to be able to call up Doors - name of door lrl then i am provided with the appropriate sizes which match the price. I need to be able to know the formula or instructions so i can follow suit for all items.

If you could provide me with the instructions to do so it would be appreciated.

Thanks

ratcat73 · 10-17-2008, 06:35 PM

G'day

Please read this link.

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

If you have any further trouble let us know

Cheers

10-15-2008, 09:41 AM	#1 (permalink)
mono-brow Registered User Join Date: Oct 2008 Posts: 2 OS: WINXP	MS Excel Drop Down issues Hi, Could somebody please provide assistence for linking data for a drop down menu on Excel. I can put normal listings in a single colum but i want to be able to pull down say A1 and that the data contained in B1 only appears when one of the ranges in A1 is clicked. Ie. A1 = types of door B1 = Sizes C1 = Prices I have looked on the net and it seems confusing. THanks in advance

10-15-2008, 12:49 PM	#2 (permalink)
sphinxheaven Registered User Join Date: Oct 2008 Posts: 9 OS: XP	Re: MS Excel Drop Down issues Hey, Thinking that we need more clarification towards this issue, however from reading i get the idea that you just might need a simple "IF" formula for Column B & C......... Please provide more information so we can asses the issue more in depth. A spreadsheet example would be perfect, use the Go Advance feature to attached a Zipped xls to us.

10-17-2008, 06:35 PM	#4 (permalink)
ratcat73 Registered User Join Date: Oct 2008 Location: Australia Posts: 51 OS: Vista Home Basic	Re: MS Excel Drop Down issues G'day Please read this link. http://www.contextures.com/xlDataVal02.html If you have any further trouble let us know Cheers