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