Is there a formula that will populate a cell w/ TEXT based on multiple criteria?

Originally Posted by TMS

Maybe:

Formula:

=IF(AND(A3="Mary",B3=4558),"A","")

Regards, TMS

Your formula doesn't seem to work for some reason. I cannot figure out what I'm doing wrong!

Posting a new "fake" template.

On the "Overall Exposure" worksheet I am trying to do a nested IF/AND formula for the "Detailed Product Type".

Example: For cell D3, I need a formula that says "If the obligation number is 481000000 and the borrower is Jane Doe, give me the Product Type that corresponds from the "Master" worksheet.

I am looking for the exact answer as found in cell N2, which is "Mars". I cannot get the cell to populate Mars. I either get a blank, or "False".

The "Master" is where all data comes from.

Do not know what to do. I feel like I've tried everything