If Index Match

Karrie Davis

Hi, 

I'm trying to figure out the due date for a submission if the dates remaining is >0 below is the formula I came up with, however it is not working. 

=IF(INDEX({Due Dates}, MATCH([Client Matter]2, {Client Matter #})), {Days Remaining}, @cell > 0)

 

Also, is there a way to do an Index Match or vlook up that gives me the entered

Paul Newcome

I'm not sure I follow. The formula you posted unfortunately doesn't shed much light on the issue.

 

Can you describe the process and desired outcome in more detail and maybe share some screenshots with sensitive/confidential data removed, blocked, or replaced with "dummy data"?