| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down sends value to another cell
Hi there. I have a drop down list with customer names. On selecting a
customer from the drop down i would like the discount % given to that customer to appear in the next cell automatically. I know it is something to do with VLOOKUP. i assume somewhere on the worksheet i need a table as follows: A B Smith 8% james 12% Steven 20% however i really need basic help as to how to write the exact formula. very basic on excel please. many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down choice sends text to another cell | Excel Discussion (Misc queries) | |||
| Import Key sends me Back to the Search page | Excel Discussion (Misc queries) | |||
| In cell drop down menu with seprerate numerical target cell | Excel Discussion (Misc queries) | |||
| auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
| how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
