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

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.


--
JasperBlaas
------------------------------------------------------------------------
JasperBlaas's Profile: http://www.excelforum.com/member.php...o&userid=12615
View this thread: http://www.excelforum.com/showthread...hreadid=379097

ill give that a try


--
DanBal
------------------------------------------------------------------------
DanBal's Profile: http://www.excelforum.com/member.php...o&userid=24079
View this thread: http://www.excelforum.com/showthread...hreadid=379097