Thread
:
referencing drop down menu values in IF-then statements?
View Single Post
#
2
Posted to microsoft.public.excel.misc
T. Valko
external usenet poster
Posts: 15,768
referencing drop down menu values in IF-then statements?
Sounds like you want to build a lookup table. See this:
http://contextures.com/xlFunctions02.html
--
Biff
Microsoft Excel MVP
"Powder Coating Mike" <Powder Coating
wrote
in message ...
I'm trying to use a drop down list to automatically input numbers into two
other cells.
eg
Drop-down menu Price 1 Price 2
what I'd like do is have it so that once I choose an item from the drop
down
menu the cells of Price 1 and Price 2 woudl be automatically filled with
the
proper number.
any suggestions???
Mike
Reply With Quote
T. Valko
View Public Profile
Find all posts by T. Valko