::Here is what I am trying to do:

I have a list of names, some names are customers, some names are
distributors. I want to know who is a disty and who is a customer.
So, next to this column of names, I have a column of Distys only. I
want to match the names in column 1 to a matching name in column 2. If
no match exists (i.e., the name is that of a customer, NOT a disty), I
want to result in either a blank field or some other way of knowing
there was no match.

This is the formula I tried and it didn't work:
*=VLOOKUP(A2;$A$2:$C$317;2;FALSE) * where the 3rd colum is where I
would see the match. However, as written, all the formula does is copy
whatever is in column 2 into column 3 (even if the names do not match).

TIA::




--
karatelovr
------------------------------------------------------------------------
karatelovr's Profile: http://www.excelforum.com/member.php...o&userid=27413
View this thread: http://www.excelforum.com/showthread...hreadid=469252