Lookup Question

[wolverine12]

Does anyone know a way (either using Vlookup and Index/Match) of flagging if I hit more than once with the lookup.

Example:

I have account numnbers which have multiple customers...but the customer data is incomplete.

ACC# CUST#
1 A
1 B
1 (blank)
2 C
etc.

So I need to do the lookup by ACC# (as the blanks within the CUST# data are numerous) but I would like to know when I get multiple hits.

Any help would be greatly appreciated.

PS: Please don't ask why the data is like this...its a nightmare !!!!

 

[DonkeyOte]

can you not simply do a countif by account number?

so COUNTIF(A2:A500,1)

where A2:A500 contains the account data (& multiples)

1 could be a reference so if you had the account number in C1

COUNTIF(A2:A500,C1)

You can then amend this to tell you where it's greater than 0

=IF(COUNTIF($A$2:$A$500,$C1)>1,"Multiple Entries","OK")

 

[wolverine12]

I guess I wasn't clear on my end goal. I think I fixed my problem nesting two lookups (if, then).

thanks for the quick response...I'm sure I'll have more questions that I'll need some help on !

 

[DonkeyOte]

Sorry Wolverine (please tell me you don't wear yellow spandex?) - think I get you now - were you wanting the locations of the multiple addresses on the list (hence the index?)