vlookup using a subtotalled data range

[Sannafay]

I'm having issues with the vlookup function. The data range that I'm using has more than one value for each material. I'm trying to return a totalled value for each material using the vlookup. I've done a subtotal for the field, copied the totals (using the Alt semicolon to get just the totalled values), and it doens't work. Help???

 

[Aladin Akyurek]

Have you considered using a formula with SumIf instead?

 

[Sannafay]

I'm not familiar with this function. I'll have to research it. It will bring back the totalled value? Thanks for the suggestion!

 

[Aladin Akyurek]

I'm not familiar with this function. I'll have to research it. It will bring back the totalled value? Thanks for the suggestion!

=SUMIF(A2:A10,"Tom",B2:B10)

sums all figures from B2:B10 which correspond to
the occurrences of Tom in A2:A10.

 

[Sannafay]

My problem is that there may be no value, one value or several values. Are you saying to put my data into a table format so the sumif could give me a value prior to the vlookup?

 

[Aladin Akyurek]

My problem is that there may be no value, one value or several values. Are you saying to put my data into a table format so the sumif could give me a value prior to the vlookup?

VLOOKUP does not total anything. I just attempted a guess that you would
need something like SumIf, a conditionally totaling function. If that's of the ball park, try to post a tiny sample
along with the desired result(s).

 

[snoopyhr]

maybe this can get your started ...

Excel Workbook
	B	C	D	E	F	G
17	Assuming your data looks something like this	*	*	*	*	*
18	Material	Value	*	*	Material	Tot-Value
19	Mat-2	458	*	*	Mat-1	134
20	Mat-1	134	*	*	Mat-2	721
21	Mat-2	263	*	*	Mat-3	339
22	Mat-5	316	*	*	Mat-4	368
23	Mat-5	356	*	*	Mat-5	1114
24	Mat-3	0	*	*	*	*
25	Mat-4	0	*	*	*	*
26	Mat-3	339	*	*	*	*
27	Mat-5	442	*	*	*	*
28	Mat-4	368	*	*	*	*
29	*	*	*	*	*	*
Sheet1

 

[Sannafay]

Hey Snoopyhr. Thanks so much for the help, and for including the example. Works fabulous!