Hello,

I was wondering if anyone would be able to assist with an Excel formula.

Basically, cells A1-C1 contain drop-down menus.

A1 has 3 options: Morrisons, Aldi, Lidl.
B1 has 2 options: 2-4, and 5-7
C1 has 7 options: 1, 2, 3, 4, 5, 6, and 7.

If A1=Morrisons, B1=2-4, and C1=1 => The result has to be £5.
If A1=Lidl, B1=2-4, and C1=1 => The result has to be £7.


Etc.

I tried the following formula: =IF(AND(A1=Aldi, B1=2-4, C1=1), 7)
However, the result is always FALSE.

If possible, would anyone be able to help me work out the formula, please?

Thank you in advance!