insert customer, identify saleperson and commission

[RAB]

I'm trying to figure out how I can enter text in one column (customer name)
and have a second column automatically populate with text (salesman) and a
third column polulate with a number (commission rate) so that I can identify
where commissions go. The customer list will be between 15 and 25, the
salesmen limited to 3 to 5. When I've tried to use VLookup, I get an error
message in my formula. Can anyone help?

 

[Mike H]

Seeing the formula that gives you a problem would help but maybe this will
get you going.


for Rep
=VLOOKUP(A1,$H$1:$J$7,2,FALSE)
For commision rate
=VLOOKUP(A1,$H$1:$J$7,3,FALSE)

Where
A1 = the Customer to lookup
H1 - J7 is a 3 column list of Customer, Rep and commision rate
The table can be anywhere, just change the range in the formula

Mike

 

[Gord Dibben]

Post your formula and a small sample of your data


Gord Dibben MS Excel MVP