hi bruce,

sorry about not posting too much! thought people might be confused!

the formula is:

=IF(ISERROR(INDEX(quarters,MATCH($A11,type,0),MATC H($I$4,quarter_list,0)))=TRUE,"£0",INDEX(quarters, MATCH($A11,type,0),MATCH($I$4,quarter_list,0)))

the data source is pictured in the piccy. the named range 'quarters'
is all the figures, 'type' is the column labelled 'type' and
'quarter_list' is the headings for the figures (1st q post exe etc).
the other two cell refs mentioned are cells with list data validation
in them, so you can choose which type and which quarter you want to
look at.

i would like to be able to choose the project name, the type and the
quarter and have the correct value returned. for example:

project number = 123456
type = claimed by BU
quarter = 1st post exe

value returned = £625


there is only one project listed (that was a fudge when i showed my
boss so the calcs all tallyed!) there will be more projects added!

i hope this makes sense!

thanks,

moonweazel


+-------------------------------------------------------------------+
|Filename: Drawing1.png |
|Download: http://www.excelforum.com/attachment.php?postid=3951 |
+-------------------------------------------------------------------+

--
MoonWeazel
------------------------------------------------------------------------
MoonWeazel's Profile: http://www.excelforum.com/member.php...fo&userid=2119
View this thread: http://www.excelforum.com/showthread...hreadid=479424