Okay, I'll try to structure this as understandably as possible:
I have an Excel Spreadsheet with 4 tabs
- The first tab is my base of operations
- I want to pull information from the 4th tab and match it with items on the 1st tab
- The first tab has a "Content ID" in the "A" column
- The 4th tab has that same "Content ID" and "rt id" in the "C" and "H" columns respectively
So what I'm trying to do is bring forth the "rt id" to the "D" column of the 1st tab by matching the "Content ID"s that are found in both tabs and are identical.
The next issue is:
- Once I have the "rt id" pulled to the 1st tab I want to query the 3rd Tab Column "G" and see if the corresponding "rt id" on that tab says "Yes" on the "G" column of the 3rd Tab.
- If it does I want to just populate a "True" or "False" on "Q" column of the 1st Tab
Finally:
- I want to query the 2nd tab columns "D" "E" and "F" to see if they say "False"
- I would ideally use the "Content ID" found on Column "A" of both tabs as they are the same
- If it does come back as "False" I would like the answer "Yes" to populate in Column "R" of the 1st Tab
- If it comes back "True" I would like it to populate "No" in Column "R" of the 1st Tab
I have looked over tutorials, but it doesn't seem to ever work and I am banging my head against the wall.
Some more information:
- 1st Tab is called custom_offers
- 2nd Tab is called Differential
- 3rd Tab is called RT
- 4th Tab is called Content
Any help is appreciated.
Bookmarks