electrobrit
New Member
- Joined
- May 10, 2018
- Messages
- 1
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
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