Formula MATCH error
 

Hi,
Can someone please change this code so that I dont get an ERROR when
the 1 (one) in the MATCH bit is not found. For some reason my brains
not working today.
Cheers, Peter





=INDEX(meal!$A5:$A9,MATCH(1,meal!B5:B9,0))


--
peterfc2
------------------------------------------------------------------------
peterfc2's Profile: http://www.excelforum.com/member.php...fo&userid=4285
View this thread: http://www.excelforum.com/showthread...hreadid=276273

=IF(ISNA(MATCH(1,meal!B5:B9,0)),"",INDEX(meal!$A5: $A9,MATCH(1,meal!B5:B9,0)))

Hope this helps!

peterfc2 Wrote:
Hi,
Can someone please change this code so that I dont get an ERROR when
the 1 (one) in the MATCH bit is not found. For some reason my brains
not working today.
Cheers, Peter





=INDEX(meal!$A5:$A9,MATCH(1,meal!B5:B9,0))


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=276273