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