Formula to give specific text if two criteria are met

[KClem]

Hi

I need specific text to result if I add in
Criteria 1 - Either £1 or £1.50; and
Criteria 2 - Either (1) 0 to 6 months (2) 6 to 12 months; or (3) 12 or more months

There are 6 different combinations that end in certain criteria.

I am stumped as to how to achieve the outcome.

i have attached an example.

Thanks

[63falcondude]

Can the cost ever be anything other than 1 or 1.5? If so, what should the result of the formula be?

[63falcondude]

Try

B3 =INDEX(C10:C15,MATCH(B1&B2,A10:A15&B10:B15,0)) Ctrl Shift Enter

[KClem]

There are only two costs £1.50 and £1.00.

So, it is really asking if the cost is £1.00 and its paid for 0 to 6 months what would the outcome be.

[KClem]

i can't thank you enough, i have been struggling with this and the other formula for a couple of days. I gave up and got help.

[63falcondude]

My pleasure, happy to help.

If that solved your question, please mark this thread as SOLVED.

[63falcondude]

Just FYI, here is a standalone formula (does not require the lookup table):

=IF(B2="0 to 6 months","Correct",IF(B2="12 or more months","Wrong",IF(B1=1,"Correct","Wrong")))

[KClem]

Thanks again