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

Posting a sample workbook showing your dilemma might help.

So from the Product category, if you pick "ALL" you want to default to Product A reason and if an actual Product is selected, get that corresponding reason? Is that correct?

If so,

Try:

Please Login or Register  to view this content.

adjust ranges to suit your data and then confirm the formula with CTRL+SHIFT+ENTER instead of just ENTER. You will see { } brackets appear.