Help with nested If/AND formula based on multiple criteria

[violenttuesday]

I'm pulling my hair out trying to figure this one out. I have a fake mock-up spreadsheet but the forum will not allow me to post attachments.

I am trying to do a nested IF/AND formula that will give me the EXACT name in a specific cell on a different worksheet. Example: "If the obligation number is 481000000 and the borrower is Jane Doe, give me the Product Type 'Mars' from Sheet 2 based on that data matching up". I keep getting either a blank cell, or "false". I need it to populate the exact word found in the cell on the other page.

If anyone can figure this one out I would really, really appreciate it!! I feel like I've tried everything

Here's what I have:

=IF(AND(A4=OBLIGATION_NUMBER,C4=BORROWER),"",DETAILED_PRODUCT_TYPE)
*(I have named ranges set up)

 

[skywriter]

Post you spreadhsheet to dropbox.

https://www.dropbox.com

 

[AhoyNC]

Try changing your formula to:

=IF(AND(A4=OBLIGATION_NUMBER,C4=BORROWER),DETAILED_PRODUCT_TYPE,"")
The first part of the if statement returns the value if true.