=IF(ISNUMBER(MATCH(B2,B$1:b2,FALSE)),INDEX(A$2:A2, MATCH(B2,B$1:b2,FALSE)),ot
her_formula)


--

HTH

RP
(remove nothere from the email address if mailing direct)


"cjjoo" wrote in
message ...

just wanna ask about the use of match and index. in this scenario, i
want the cell to perform a match index and if there is a match, it will
return the value, if thee is no match, carry out another formula. This
is the scenario:


A B
01 x123
02 y456
01 x123

in this e.g, the formula use in A2
=INDEX(A$2:A2,MATCH(B2,B$1:b2,FALSE))

but if there is no match, the cell will return a NA but now i would
like the cell to perform another formula if there is no match . Can it
be done using IF function?

something like if match, do_match(index),
if_no_match_carryout_other_formula?

hope that i am clear..


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