VLookup & Match?
 

Hi,

Not sure what to call my situation, but I'll try to explain. I created a
timesheet & want to find out how much time was charged to a particular charge
number, "WITHOUT" calculating the total time - Already have a formula for
this.

Basically, I have a list of charge numbers. Some charge numbers may be
repeated several times.

I have a summary report in which I want to find a particular charge number
from the list. In my summary, I have a column in which I want to
"automatically" find or import the chage numbers being used.

Example:

Available Charge #'s
123
456
789

Charge numbers actually used:
123
456
123


Summary List:

** I would like a formula that recognizes the Available Charge # list,
match the charge numbers being used without double counting, then produce the
results:

I don't have a forumla because I'm not sure what's available or how it may
be work.

Any assistance would be appreciated.

Thanks

VLookup & Match?
 

You should reply to my response (stay) in your original thread. That's the
way to have great discussions going in the newsgroups. I gave you an
index/match suggestion in your earlier posting, with customary details on
the sheets' set-up assumptions made. Didn't that work for you?

You could also upload your sample file/data using a free filehost, then post
a link to it here.

Eg, you could use this free filehost to upload:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload,
then paste it here
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jason" wrote in message
...
Not sure what to call my situation, but I'll try to explain. I created a
timesheet & want to find out how much time was charged to a particular
charge
number, "WITHOUT" calculating the total time - Already have a formula for
this.

Basically, I have a list of charge numbers. Some charge numbers may be
repeated several times.

I have a summary report in which I want to find a particular charge number
from the list. In my summary, I have a column in which I want to
"automatically" find or import the chage numbers being used.

Example:

Available Charge #'s
123
456
789

Charge numbers actually used:
123
456
123


Summary List:

** I would like a formula that recognizes the Available Charge # list,
match the charge numbers being used without double counting, then produce
the
results:

I don't have a forumla because I'm not sure what's available or how it
may
be work.

Any assistance would be appreciated.

Thanks