Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Lookup Function not working


Here is my function:

=LOOKUP(A18,'Week 1 Totals'!A18:A94,'Week 1 Totals'!J18:J94)

For some reason this is not working for me. I am trying to find a
total number of hours worked for a given job. A18 is a job number.
A18:A94 on week 1 totals sheet is a range where the job numbers are
located for each job. J18:J94 on week 1 totals sheet is where the
total hours are for each job. For some reason this function is
returning 0 even though J18 = 1 where A18 on the current sheet matches
A18 on the week 1 totals sheet. So it should return 1. I cant figure
out why its not working. Any one know why.


--
hcamelion
------------------------------------------------------------------------
hcamelion's Profile: http://www.excelforum.com/member.php...o&userid=36736
View this thread: http://www.excelforum.com/showthread...hreadid=568541

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Lookup Function not working


That worked great but there is one problem: Week 1 Totals sheet may or
may not have the job # I am calling as only jobs that were worked that
week show up on that sheet. When vlookup does not find the
corrosponding job number it returns #N/A. I need it to return 0 when
the job is not on the week 1 totals sheet. Any ideas. I tried doing
an if...if the vlookup = #N/A display 0 if not display the vlookup
result. But I guess that doesnt work with errors. Any ideas.


--
hcamelion
------------------------------------------------------------------------
hcamelion's Profile: http://www.excelforum.com/member.php...o&userid=36736
View this thread: http://www.excelforum.com/showthread...hreadid=568541

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Lookup Function not working


Use ISERROR

=IF(ISERROR(VLOOKUP(A18,'Week 1
Totals'!A18:J94,10,FALSE)),0,VLOOKUP(A18,'Week 1
Totals'!A18:J94,10,FALSE))

-ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=568541

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
lookup function cindy Excel Worksheet Functions 3 April 19th 06 07:28 PM
LOOKUP function haroldhagar Excel Worksheet Functions 2 August 6th 05 07:38 PM
Pivot table doing a lookup without using the lookup function? NGASGELI Excel Discussion (Misc queries) 0 August 2nd 05 05:08 AM
Excel option to store trendline's coefficients in cells for use Miguel Saldana Charts and Charting in Excel 9 June 20th 05 08:45 PM
Lookup function returning reference, not value Caligula Excel Worksheet Functions 1 May 28th 05 06:35 PM


All times are GMT +1. The time now is 02:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"