![]() |
HLookup returning values
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? -- searcherlady |
All times are GMT +1. The time now is 04:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com