Return text based on criteria

Hi, i am not sure what to search for. I need a formula that will return text based on criteria that i set.

Example: I have 2 sheets, a pivot and a data sheet. When selecting a different option on the pivot i want information returned from the data sheet (which is explanations of the information contained in the pivot) I need to add 2 criteria points

Thanks


edit: the "sumifs" functions is in the direction that i am thinking, but it doesn't do the text return