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

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


--
Billznik
------------------------------------------------------------------------
Billznik's Profile: http://www.excelforum.com/member.php...o&userid=37119
View this thread: http://www.excelforum.com/showthread...hreadid=568499

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

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

On Fri, 4 Aug 2006 17:05:56 -0400, Billznik
wrote:


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