Dav,

I tried your formula and it didn't work. If column B matches, it returns the
column D value regardless if column C matches or not. FALSE is not an error.
I rewrote it as follows, and it works:

=IF(MATCH(Blank!B18,Miles!B3:B16,0)=MATCH(Blank!C1 8,Miles!C3:C16,0),OFFSET(Miles!D2,MATCH(Blank!B18, Miles!B3:B16,0),0),0)

Hutch

"Dav" wrote:


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