View Single Post
  #1   Report Post  
DanBal
 
Posts: n/a
Default spread sheet search


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