Can Excel automatically recognize what name coordinates with certain accounts?

Hi, welcome to the board

Yup, this sounds do-able.

You don't give much detail to work on, but assuming your data looks something like this...

	A​	B​	C​	D​	E​	F​
1​	ACCT	Name			Acct	Name
2​	11​	aa			11​	aa
3​	22​	bb			22​	bb
4​	33​	cc			33​	cc
5​	11​	aa
6​	22​	bb
7​	33​	cc
8​	11​	aa
9​	22​	bb
10​	33​	cc

B2=IF(A2="","",VLOOKUP(A2,$E$2:$F$4,2,0))
copied down

E1:F4 would be the table containing the names and accounts

kaesco2 said:

This is for a commissions report where I enter the sales rep who earns commissions on accounts they call on. Currently I am putting the accounts in ascending order and manually entering the sales rep. Is there a way that I can enter the account in one column and have the other column automatically recognize who it belongs to?

Click to expand...

Personal computers are among the dumbest of all creatures. If they have any intelligence, it is artificial. The basic answer to your question is "No". But a cross reference listing can be set up and used to identify accounts to names. If Arnold had 3 accounts, Betty had 2 and Charlie had 4, you could set up a cross reference for each person to their respective accounts and then in other places when an account is entered, refer to that indexed listing to get the corresponding name. You would need to elaborate on your project goals somewhat to get a better response.

oops posted twice, forum seems slow

Thanks you for the response! It resembles this yes. But some people have more than one account. where would I input that formula?

I am not able to view images , based on my sample, what would the data look like?