monkeydan,

This should work for you.

=IF(AND(A2="UK / NI",AB2="A"),762,IF(AND(A2="UK /
NI",AB2="B"),822,IF(AND(A2="UK / NI",AB2="C"),Your C Value
here,IF(AND(A2="ROI",AB2="A"),1315.59,IF(AND(A2="R OI",AB2="B"),1490.94,IF(AND(A2="ROI",AB2="C"),Yo ur
C value here))))))

Another option. Set up a table somewhere on your sheet say in
AZ1:BB6.


ROI A 1315.59
ROI B 1490.94
ROI C 1
UK / NI A 762
UK / NI B 822
UK / NI C 2

Then in AC3.

=SUMPRODUCT((AZ1:AZ6=A2)*(BA1:BA6=AB2)*(BB1:BB6))

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=567465