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$150))

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$15 0))

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