Aha! We're almost there. Post (in this thread) the formula that works
for you for the, for example, Jan result for a single occurrence of, for
example, 1000.

Alan Beban

Jonsson wrote:
Okey, Alan

Sorry for being in the wrong newsgroup. But as I´m already here I hope we
can finish this question in this group.
However, what I´m trying to do is this:
I have rows for several different persons in a sheet called "v1", and one
row for each customer in a sheet called"Jan".
Everytime I write for instance "1000" in "v1", I want excel to return a
value in "Jan" thats connected to "1000".
My formula can do that, no problem.
But, when "1000" appears in the same column in "v1" several times I dont
know how to get the values
summed.

I´m also sorry for my poor english, but I hope you can understand what I´m
trying to accomplish.

//Thomas


"Alan Beban" skrev i meddelandet
...

And fourth, this thread should be in . . .worksheet.functions, not in
. . .programming.

Alan Beban

Richard Choate wrote:

The lookup function will return one record as a result, based on your
criteria., Therefore there is nothing to add. If you have several

lookups in

a column, you can run a sum on the group of lookups, but you can't sum a
single lookup. Your example does not seem to make sense. The first

parameter

should be a single value or cell reference. The other 2 should basically
allow you to tell where you want to find it. Check the syntax in help.
Generally it is like: =(LOOKUP(C$206,'v1'!O$3:O$150)).
--
HTH
Richard Choate, CPA

"Jonsson" wrote in message
...
Hi Richard
Sorry, I forgot the english is different.
This is the english version

=(LOOKUP(C$5:C$206;'v1'!O$3:O$150;'v1'!S$3:S$15 0))


How to get a summary from several of the same lookup- value from sheet

"v1"?

I have tried to write "SUM" before "(LOOKUP", but that does´nt work.


What shall I do to get it right?


Regards,


//Thomas




"Richard Choate" skrev i meddelandet
...


What is the english version of your question please? What is LETAUPP?
--

Richard Choate, CPA

"Jonsson" wrote in message
...
Hi,

I have this formula:

=(LETAUPP(C$5:C$206;'v1'!O$3:O$150;'v1'!S$3:S$ 150))

How to get a summary from several of the same lookup- value from sheet

"v1"?


I have tried to write "Summa" before "(letaupp", but that does´nt work.
What shall I do to get it right?

Regards,

//Thomas