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,F ALSE)=ERROR.TYPE(#N/A),"No
Time",(HLOOKUP(D2,ShopHours!$B2:ShopHours!$HF200,4 4,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
--
DanBal
------------------------------------------------------------------------
DanBal's Profile:
http://www.excelforum.com/member.php...o&userid=24079
View this thread:
http://www.excelforum.com/showthread...hreadid=379097