Drop down menu in excell

[mtevensorrison]

Hello

Ive been given a wee job by my gaffer which includes the following!

i will create a drop down list from 1 - 10

when a number is selected, the cell next to it will be filled by text which is linked to the chosen number!

there may also be some calculations to be performed in the cells next to the text cells also!

does anyone have any ideas??

regards in adavance

 

[xlbo]

I've tested this and it returns "" even when there is data in the referenced Cell!

I bet you it doesn't

If the dropdown list is in cell A1 and nothing is selected, the formula:
=if(A1="","",VLOOKUP(A1,Price,2,FALSE))
will return "" as the 1st part of the IF is true

If something is selected and A1 is populated then the 2nd part of the IF statement is true and the vlookup will be executed. The ONLY way this will not work is if you have calculation set to manual in the workbook (Tools>Options>Calculation)

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question