I have a code that I want to lookup a value in another sheet if the date is past due
I want the cell to yield current if N6 - O6 >20, but if it is N6-O6 <20 I want it to search 'Monthly Claims'!G6 for a value if there is a value I want it to yield "Entered" if there is not value I want it to yield "Not Entered Yet"=IF($N$6-$O$6>20,"Current""=IF('Monthly Claims'!G6>0,""Entered")
Bookmarks