Is there a formula that can Return a text value if multiple criteria are met?

Hello -

I'd essentially like to create a ReturnValueIFS formula. I'd like it to function the same way as a SUMIFS, except instead of summing numbers together it would return the text value.

Is this possible?

ReturnValueIfSample.xlsx

Here is a sample.

Basically, I'll be referencing a master table of Meta Data. I want to be able to attach Meta Data to the right record. There is a table for Projects and To-Dos. The master list of Meta Data contains information for both of those objects (Projects and To-dos).

For To-Dos, Projects I have a separate tables, I want to attach the Meta Data to the record in the table it belongs to.

This is my first questions on the forum, so let me know if you need any additional information.

My final solution.

I concatenated the names in the Meta Data worksheet, ex. 123ProjectAsset Type. I was able to create this name in the Project worksheet. I then just did a simple Index, Match.