Using multiple arguments

Hello,

I have cell A3 as a drop down list & cell B3 as a drop down list.

Each list contains 15 items.

so in theory, there is 225 different combinations that A3 & B3 could show.


I need a formula (or another easier method) for these combinations..

eg;

=IF(A3="item1" AND B3 = "item1","green book",IF(A3="item1" AND B3="item3","Red book",IF(........................etc


How do i check 2 criteria to then return a true or false?

I have a table ready which will look similar to this:

ITEM1 ITEM1 GREEN BOOK
ITEM1 ITEM2 YELLOW BOOK
ITEM1 ITEM3 RED BOOK
ITEM1 ITEM4 BLUE BOOK
ITEM1 ITEM5 BLACK BOOK
.
..
...
ITEM15 ITEM1 GREEN CASE
ITEM15 ITEM2 YELLOW CASE
.
etc etc..


please help

You can do this with helper columns and VLOOKUP.

In the attachment, the helper cells are in yellow and concatentate the two individual values into a composite. The composite value is then used for look up.

i'd use an index match approach with all combinations listed
see attached