VLOOKUP with conditional criteria.

This returns unparseable:

=INDEX({2020 CSTE Media Tracking Range 2}, MATCH({2020 CSTE Media Tracking Range 3}@row, {2020 CSTE Media Tracking Range 1}, 0))

This returns circular reference:

=INDEX({2020 CSTE Media Tracking Range 2}, MATCH(Contact@row, {2020 CSTE Media Tracking Range 1}, 0))

This just returns the outlet.

=INDEX({2020 CSTE Media Tracking Range 2}, MATCH(Outlet@row, {2020 CSTE Media Tracking Range 1}, 0))

Just to confirm, this sheet:

Is pulling from this sheet:

Oh god FINALLY. It's working!

Even better, it's properly populating on my dashboard.

Thank you so much for your time, this has been a huge headache for me. One last question, though; there's one tiny hitch.

While the formula populates contacts to outlets if more than one contact is added to a line, it won't take a contact from a different column with the same outlet and add them to my target sheet in the appropriate cell. Is this even possible or am I asking a little too much?

I'm using an actual Contact type column for both the target sheet and the original sheet.

Would it work if I just used a regular text/number type column? They don't need to be automated, they need to be there for overview purposes.

It works perfectly. Thanks so much for all your help.

Hey, I just have one more question. A few cells are populating duplicates (due to the same reporter from the same outlet having multiple inquiries). Is there a way to exclude a name if it appears more than once?

I tried this(it also seems that SmartSheet changed my formula to join/collect):

=JOIN(COLLECT({2020 CSTE Media Tracking Range 1}, Count:Count, >1, {2020 CSTE Media Tracking Range 2}, Outlet@row), "; ")

It returns as unparseable.

Wow, this is perfect. Thank you.

Hey there, I hope it's alright to ping you again. This formula is working beautifully with one minor hiccup:

For some reason, some of the names populate with no space or semi colon between them. For reference, this is the formula I used:

=JOIN(DISTINCT(COLLECT({2020 CSTE Media Tracking Range 1}, {2020 CSTE Media Tracking Range 2}, Outlet@row), "; "))