LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default vlookup with a sum of array

Please some one!! help!!
I have been trying to solve this problem for couple of days, but not luck.
Here is my question! I really hope someone can help me.
I have a table with a job ID and working hours. Ex.

Column "A" (jobs)
501350
500854
513501
254789
501350


Column "B" (working hours)
4
3
5
7
4

I have on another worksheet a list of all my current jobs without any time
(work hours). I know how to use a vlookup formula to identify a job and
return a specific value, but I need a combination of two formulas (maybe the
vlookup and other) or a new formula to add the working hours of a specific
job in my second worksheet.

For example, if I have on column "A" of my second worksheet the job #
501350. I need a formula to look for this specific job# and add (sum) the
working hours on all of them. In this example, it should be a value of "8". I
need this value on column "B" next to the job on my second worksheet. Which
is 4 + 4 on job# 501350 of my first worksheet.

Thanks a bunch!!


 
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
vLookup with multiple lookup value in table array [email protected] Excel Worksheet Functions 2 September 26th 06 04:12 PM
Array Brad Excel Worksheet Functions 9 October 17th 05 09:00 PM
How do i lengthen an existing VLOOKUP table array? artesia7 Excel Worksheet Functions 5 October 17th 05 03:11 AM
sumif based on vlookup array Brian Winkler Excel Worksheet Functions 6 October 16th 05 01:52 PM
How to use a cell value as Table Array in VLOOKUP worksheet function willydlish Excel Discussion (Misc queries) 2 February 16th 05 02:47 AM


All times are GMT +1. The time now is 03:32 AM.

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

About Us

"It's about Microsoft Excel"