FORMULA HELP: nested if - 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 of each sheet 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

Thanks in advance!

Based on what you have shared in post #1, try this:

=INDEX(Export!B$2:Q$72,MATCH(A2,Export!A$2:A$72,0),LOOKUP(B2,{"CONF","PMS","TTT BOOKING FEE","TTT COMM","TTT RESV FEE- 3PH","TTT RESV FEE- ABI","TTT RESV FEE- CHI","TTT RESV FEE- JAM","TTT VOICE UPSCALE","TTT WEB-3PH"},{16,15,1,5,8,3,3,3,9,11}))

Hey 63falcondude! this is so close. THANK YOU. However not everything works and I can't figure out why, i.e. if you filter to column a on both sheets 62911 there are 2 #s missing that show up on export. It doesn't look as if exact match is an issue.
One thing, I might could try and troubleshoot except can you tell me what these numbers at the end of the formula are doing?>>>> {16,15,1,5,8,3,3,9,11}

Thanks again, this is the closest I've gotten!

{16,15,1,5,8,3,3,9,11}

It represent no. column

use at
=index(array,row,column[here])

you may use =Column() to get the column number.