It is because you areonly allowed 7 levels of nesting in excel, thats
where you formula fails

However you could use another formula

=IF(ISERROR(MATCH(blank!b18,Miles!B3:b16,0)=MATCH( blank!c18,Miles!c3:c16,0)),0,OFFSET(miles!d2,MATCH (blank!b18,Miles!b3:b16,0),0))

That should work if I have typed it correctly

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=559359