View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
searcherlady searcherlady is offline
external usenet poster
 
Posts: 8
Default 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