=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