Need help: nested if where it's based on criteria in one column then return values from another column

[electrobrit]

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. (BTW-I spent some time trying to figure out how to load pics but didn't work. Maybe someone can invision this.)

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

 

[oldbrewer]

master sheet

pretend export sheet

fred

thistext

no match

bill

thistext

jo

thattext

no match

jo

thistext

dave

othertext

match

dave

othertext

c2 formula

=IF(AND(A2=L2,B2=M2),"match","no match")

you would need to make L2 into export!l2 etc

<colgroup><col span="15"></colgroup><tbody>
</tbody>