| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I make a new spread sheet pop up, based on an entry in a c. | Excel Discussion (Misc queries) | |||
| Excel window in spread sheet? | Excel Discussion (Misc queries) | |||
| Search for a Sheet | Excel Discussion (Misc queries) | |||
| How do I get rid of spare lines in an excel spread sheet? | Excel Worksheet Functions | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Threaded Mode
