![]() |
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 |
All times are GMT +1. The time now is 04:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com