Have excel recognize a name and associate it with a value?

B

Billznik

I have a master list of customers to whom I pay a certain percentage o
commision which I specify. Each month I receive reports of th
commisions my customers have generated but each month is different
sometimes some customers appear and others don't. Is there a way wher
I can use a master list which identifies which customers receive wha
percentage and have excel automatically enter this percentage next t
their name when their names appear in my reports? Right now I a
copying and pasting the info I receive from the reports and entering b
hand the percentage each will receive by checking my master list
Thanks
 
G

Gord Dibben

This could be done using the VLOOKUP function.

You have a master list on say, sheet2

A1:A100 is names

B1:B100 is percentage

On sheet1 in B1 enter =VLOOKUP(A1,sheet2!$A$1:$B$100,2,FALSE)

Enter a name in A1 and percentage will appear in B1.

Ranges are examples only but these are the basics.


Gord Dibben MS Excel MVP
 
Top