Seanzie Wrote:

What is wrong with this formula?


Where do you want to start??

You'd probably be advised to try to shorten it - as you're actually
returning values from a 3x2 table (multiplied by D4) you'd probably be
better off with INDEX/MATCH like this

=INDEX('customer account
numbers'!B3:C5,MATCH(B4,{850,749,649},0),MATCH(C4, {"National","Regional"},0))*D4


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=506598