This is the same question that you asked and I answered yesterday, albeit
with two less conditions. What is wrong with the previous answer?
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"cjjoo" wrote in
message ...
this is my problem:
A B
1 ann
2 bob
3 catie
1 ann
in clm B, the names are in a drop-down list . So in the last row, once
ann is
assigned, it is possible in A4 that it returns the number that has been
previously
assigned to ann? so if i key in catie in B5, A5 should return 3.
--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=477774