ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   HLookup returning values (https://www.excelbanter.com/excel-worksheet-functions/143167-hlookup-returning-values.html)

searcherlady

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