Why is IF returning #VALUE!? Seem correct to me.

[Camel123]

Hi,

Below is part of the formula. The error is in the beginning.

When evaluating; first logic test= FALSE, instead of running the formula in the "FALSE" section, it returns #VALUE !. Why? I can not see anything wrong.



=IF(D4="";"manual";IF(DATEVALUE(INDEX('planned'!J:J;MATCH('booked'!D4;'planned'!E:E;0)))<DATEVALUE($E$2)... formula continues...

 

[DanteAmor]

I did not do much, but it is important that in the following occasions present examples of what you have and what you expect results, that helps us to help you.