Hello,
I cant get the following to work.
But range "O1" is =TODAY()![]()
=IF(P2>HLOOKUP(O1,$E$14:$P$16,3,0),1,0)
When I remove the formula in "O1" it works. I guess it can't reference a cell with a formula?
How can I get this to work?
Thank you,
Hello,
I cant get the following to work.
But range "O1" is =TODAY()![]()
=IF(P2>HLOOKUP(O1,$E$14:$P$16,3,0),1,0)
When I remove the formula in "O1" it works. I guess it can't reference a cell with a formula?
How can I get this to work?
Thank you,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks