Here is a way to return the two-item match without using nested IF's and it is easy to extend to either more items in the list or even a third column to match against.
For this example, my table was in columns A, B & C, rows 2 to 11, like this:
A B C
2 Horn Circuit CONTROL FCM XP6-CA
3 Relay RELAY FRM-1A
4 Pull Station MANUAL STATION NBG-12LX
5 Latch Superv MONITOR FMM-1A
6 Monitor MONITOR FMM-1A
7 Monitor MINI/DUAL MON FDM-1A
8 Latch Superv MINI/DUAL MON FDM-1A
9 Pull Station MINI/DUAL MON NFM-950B
10 Smoke(Photo) PHOTO FSP-851A
11 Smoke(Ion) ION FSI-851A
I had the first selection in cell D12 (for col. A) and the second in D13 (for col. B)
You can change these addresses to the appropriate worksheet/cell as required.
The final result is returned using the offset function.
The SUMPRODUCT() function returns the row number of the matching combination and this has to be adjusted based on which row the table starts on. You will see a '-2' near the end of the formula, and this takes account of where the table starts.
The reference to C2 at the beginning is the first cell in the table in the results column (column C in this case).
This is the formula:
In the example, Pull Station and MINI/DUAL MON returned NFM-950B.
As a note for future posting, put your data between <pre> and </pre> tags that you can insert using the 'Pre' icon above the reply box. Then use the Preview button and edit, as required. To preview again, check the 'Check To Show Confirmation Page Again' box and click 'Confirm and see post'
If you have a question that is about another issue, even if for the same project, could you start a new post, with a new title. It makes it easier to track questions and answers.