ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Drop down sends value to another cell (https://www.excelbanter.com/excel-discussion-misc-queries/150826-drop-down-sends-value-another-cell.html)

Ali

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