Need help nested if where based on criteria then return values from another column

I have 2 spreadsheets. One is the Master, the other is called Export. I need to get the numbers from the export into the master (column C) each month based on the item row name and the IDs in column A need to match. I kept trying: IF column B CONTAINS this, then pull in column T from other spreadsheet where column A matches on both spreadsheets (I was using index/match). I can't get it to work. I've attached an example and the formula logic is on third tab (easier to read than below)

2 spreadsheets
Master
Export

If Column B in the Master contains this text "TTT RESV FEE- 3PH", then Return value from Export column N, where Column A matches in both, otherwise blank or 0
If Column B in the Master contains this text " TTT RESV FEE- ABI", then Return value from Export column D, where Column A matches in both, otherwise blank or 0
If Column B in the Master contains this text "TTT RESV FEE- CHI", then Return value from Export column D, where Column A matches in both, otherwise blank or 0
If Column B in the Master contains this text "TTT RESV FEE- JAM", the Return value from Export column D, where Column A matches in both, otherwise blank or 0
If Column B in the Master contains this text "TTT VOICE UPSCALE ", then Return value from Export column J, where Column A matches in both, otherwise blank or 0
If Column B in the Master contains this text "TTT WEB-3PH", then Return value from Export column L, where Column A matches in both, otherwise blank or 0
If Column B in the Master contains this text "TTT BOOKING FEE", then Return value from Export column B, where Column A matches in both, otherwise blank or 0
If Column B in the Master contains this text "TTT COMM", then Return value from Export column F, where Column A matches in both, otherwise blank or 0
If Column B in the Master contains this text "CONF", then Return value from Export column Q, where Column A matches in both, otherwise blank or 0
If Column B in the Master contains this text "PMS", then Return value from Export column P, where Column A matches in both, otherwise blank or 0

The following IF(...SUMIFS... based formula seems to work:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.