S
searcherlady
If I use HLookup on a table and the result of the comparison is false, how do
I not change an existing value in the cell?
i.e.: =HLOOKUP(I14,Sheet1!K19:O28,10,TRUE)
I14 is a date. If the date is past and there is a value in the cell, I do
not want that value to change. Is there any way of doing this?
I not change an existing value in the cell?
i.e.: =HLOOKUP(I14,Sheet1!K19:O28,10,TRUE)
I14 is a date. If the date is past and there is a value in the cell, I do
not want that value to change. Is there any way of doing this?