spread sheet search

[DanBal]

i am using the following to search out information and return other info
to a different sheet.

=IF(HLOOKUP(D2,ShopHours!$B2:ShopHours!$HF200,44,FALSE)=ERROR.TYPE(#N/A),"No
Time",(HLOOKUP(D2,ShopHours!$B2:ShopHours!$HF200,44,FALSE)))

my problem is: when no information is found it is still returning and
#n/a.

can anyone help.

I would also like to be able to copy this new sheet into other books
but it keeps on changing the references.

tks
Daniel

 

[JasperBlaas]

I usually use:

if(isna(HLOOKUP(D2,ShopHours!$B2:ShopHours!$HF200,44,FALSE),"No
Time",HLOOKUP(D2,ShopHours!$B2:ShopHours!$HF200,44,FALSE)

Maybe that works better for you.

 

[DanBal]

ill give that a tr