Hi,

Think this should do it for you

=IF(AND(A2="UK /
NI",AB2="A"),762,IF(AND(A2="ROI",AB2="A"),1315,IF( AND(A2="UK /
NI",AB2="B"),822,IF(AND(A2="ROI",AB2="B"),1490,IF( AND(A2="UK /
NI",AB2="C"),919,1699)))))


The 'or' that you were using was the reason you were only getting the
same value for all your answers - needs to be an AND command

Hope that helps

Regards

Carl


--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=567465