sorry to ask u something again...

in the previous eg, in b2 , it is key in by the end user.So now, i want
(in A2) that

reads if there is any input in B2. IF b2="", return "", If there is an
input, match

with previous records , if_match, return_match_value, if_no_match,
carry out

another formula.

i am not sure how to arrange all this in the nested IF s format in the
logical

sequence , pls advise.....


--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=478698