Try this:

=INDEX({1315,1490,1699,762,822,919},MATCH(A2&AB2,{ "ROI","ROI","ROI","UK /
NI","UK / NI","UK / NI"}&{"A","B","C","A","B","C"},0))

I assumed <spaces before and after the slashes in "UK / NI".
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"monkeydan" wrote
in message ...

Hi there,

I'm having a problem setting up the following; any help you can give me
would be much appreciated.

In cell A2 I have a dropdown menu from which you can only select "ROI"
or "UK / NI"

In cell AB2 I have a dropdown menu from which you can select Package
"A", "B", or "C"

In the next cell (AC3) I want to enter a formula which will
automatically enter an amount corresponding to what is selected in A2
and AB2.

So if UK is selected, package "A" = 762, package "B" = 822 and package
"C" = 919

If ROI is selected, package "A" = 1315, "B" = 1490, "C" = 1699

If I try and add the section for "C" into the formula I have, it tells
me I have too many arguments. At the moment the amount in AC3 changes
when you select "A" or "B" when ROI is selected from the dropdown, but
it stays on 762 no matter what package you choose when UK / NI is
selected.

This is the formula so far...

=IF((AND(A2="ROI",AB2="A")),1315.59,(IF((OR(A2="UK /
NI",AB2="A")),762,(IF((AND(A2="UK /
NI",AB2="B")),822,(IF((OR(A2="ROI",AB2="B")),1490. 94)))))))

But it ain't working properly


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