If Formula is not working

Occasional Visitor

Hi All,


This is my first time on this community. Hoping will get some good diagnosis and solution for my issue.


I have an IF condition that is working for one data set but not for another similar dataset. I am not able to figure our why? Attached are the print screens for review.


Can someone please help?



2 Replies
It looks like you might be off by a row on the 2 examples that aren't working. You could use a vlookup instead of an if statement so that wouldn't matter so much as long as you grabbed the whole section you are trying to reference. This is my first time on this too!

It's hard to say without the file. As a variant that could be extra space or invisible character in "Commitment Fee" text in your table. To check in any empty cell =(G2="Commitment Fee")