Re: Match Index


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?action=getinfo&userid=26916
View this thread: http://www.excelforum.com/showthread.php?threadid=478698

.

Relevant Pages

  • countif"s
    ... completed was in the datas. ... cjjoo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26916 ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Pls Help!
    ... hey guys i got tks alot!! ... cjjoo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26916 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Convert a string value to numeric and sort
    ... What I want is to put those numbers in order of sequence. ... The Val function stops as soon as it recognizes a non-numeric value. ... mariomaf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30098 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Routine that saves a file. If more than 7 in directory, deletes the oldest.
    ... The files are in sequence but the numbers may not be one after the ... wayliff's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29860 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • count problem
    ... this 1 and o sequence is very ... muumigirl's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30674 ... Prev by Date: ...
    (microsoft.public.excel.programming)
Loading