data validation list

April 3, 2011 at 16:30:29
Specs: Windows XP
With in Data Validation List:

D6 Apples, Oranges, Grapes, Watermelon

If I select Apples I need to have H6 be: 12.00
If I select Oranges I need to have H6 be: 32.00

What language do I use to get this H6 column to add this number automatically when a variable is selected from drop down list?

Thank YOU!!!

See More: data validation list

Report •

April 3, 2011 at 17:47:22
What language do I use

You don't us a language, you use a formula.

In cell H6 you would use somthing like:



Report •
Related Solutions

Ask Question