VLookup

[SammySpaceman]

Is it possible to have VLookup return more than one value at a time?

 

[Aladin Akyurek]

On 2002-08-20 15:27, PaddyD wrote:
he trying to do this:
http://www.mrexcel.com/board/viewtopic.php?topic=19510&forum=2&3

...which can't be done with a formula if I understood him right...

 

[Mark W.]

On 2002-08-20 15:30, Aladin Akyurek wrote:

On 2002-08-20 15:27, PaddyD wrote:
he trying to do this:
http://www.mrexcel.com/board/viewtopic.php?topic=19510&forum=2&3

...which can't be done with a formula if I understood him right...

Gee, I believe I've just done the impossible! :wink:

 

[PaddyD]

Not the first time, surely!

 

[Mark W.]

On 2002-08-20 15:34, PaddyD wrote:
Not the first time, surely!

No, no... some consider ME to be Impossible!

 

[Aladin Akyurek]

On 2002-08-20 15:32, Mark W. wrote:

On 2002-08-20 15:30, Aladin Akyurek wrote:

On 2002-08-20 15:27, PaddyD wrote:
he trying to do this:
http://www.mrexcel.com/board/viewtopic.php?topic=19510&forum=2&3

...which can't be done with a formula if I understood him right...

Gee, I believe I've just done the impossible! :wink:

Another circ reference...

Have a look at...

http://www.mrexcel.com/board/viewtopic.php?topic=19485&forum=2&6

unless I'm missing something.

 

[SammySpaceman]

Hi, I apologize for the confusion. I was looking to do it Mark W's way--using the array to achieve multiple results. However, I appreciate Juan Pablo G's help very much so because his information is useful for using multiple criteria for the VLookup. Thank you both very much! Also, thanks to PaddyD and Aladin for elaborating on my goal.
This message was edited by SammySpaceman on 2002-08-20 17:29

 

[timbatop]

I think i'm trying to do the same as the original poster, and I dont think it has been answered, so:

I'm trying to get VLOOKUP to return the sum of corresponding values to multiple rows that meet the criteria. E.g. - in the example below, i want the sum of the Total Scores related to SIC code 1... (ie. - 513)

Putting array brackets in doesnt seem to work either...
Please help!
___________________________
SIC-2digit Total score


1 8
1 14
1 16
1 18
1 48
1 50
1 74
1 120
1 165
2 8
2 31
5 15
5 18

 

[Aladin Akyurek]

On 2002-08-21 01:53, timbatop wrote:
I think i'm trying to do the same as the original poster, and I dont think it has been answered, so:

I'm trying to get VLOOKUP to return the sum of corresponding values to multiple rows that meet the criteria. E.g. - in the example below, i want the sum of the Total Scores related to SIC code 1... (ie. - 513)

Putting array brackets in doesnt seem to work either...
Please help!
___________________________
SIC-2digit Total score


1 8
1 14
1 16
1 18
1 48
1 50
1 74
1 120
1 165
2 8
2 31
5 15
5 18

No, you need something different...

Let A1:B14 house the sample including the labels.

In D2 enter: 1

In D3 enter: 2

In E2 enter & copy down:

=SUMIF($A$2:$A$14,D2,$B$2:$B$14)

See the figure...

Book21
	A	B	C	D	E
1	SIC-2digit	Totalscore		SIC-2digit	Total
2	1	8		1	513
3	1	14		2	39
4	1	16
5	1	18
6	1	48
7	1	50
8	1	74
9	1	120
10	1	165
11	2	8
12	2	31
13	5	15
14	5	18
Sheet1

 

[daveyscouse]

Hi guys, I am trying to figure out the code that Juan sent in this thread.

However, when I try it all I get is the first result over and over again instead of a list of the results.

Is there a problem with the code, Juan can you help at all??

Davey

 

[PaddyD]

Davey,

I think you'd be better off starting a new thread for this. outline you data & what you're trying to do. Post a link to this thread for the udf code. Makes things less 'cluttered'.