using logic values
i want to make a chart that i will be able to select an item from a
drop down menu, then have it place a value into another cell. ex: if i select "plain black" i want cell b1 to say "$20 or if i select "fancy black" i want cell b1 to say "$40" or if i select "white" i want cell b1 to say "$10" can this be done without writing a script? excel 2003 |
using logic values
See VLOOKUP function.
" wrote: i want to make a chart that i will be able to select an item from a drop down menu, then have it place a value into another cell. ex: if i select "plain black" i want cell b1 to say "$20 or if i select "fancy black" i want cell b1 to say "$40" or if i select "white" i want cell b1 to say "$10" can this be done without writing a script? excel 2003 |
All times are GMT +1. The time now is 07:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com