Lookup unsorted names and return only value associated with name

[grantjw]

I have 3 colums of data Name, Net and Gross. in 4th column I would like to find only values assoicated with Name "A". in the 5th coulmn only find values associated with Name "B". Thanks for your help!

Name	net	Gross	A	B	C	D
A	508	-200.129
C	17	-34.5861
D	241	-64.784
A	449	-171.537
B	445	65.606
A	411	-157.414
D	251	-44.4871
B	359	-22.8478
C	96	-27.9752
A	397	101.685
A	402	-152.452
C	89	-23.3072
A	422	-141.114
B	444	51.4022
D	233	-33.4352
A	450	-91.0501
C	84	-16.5229
A	510	73.982
C	85	-19.5838
B	454	-13.6608
B	408	-23.8842
C	86	-15.9449
D	229	-42.8249

<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669" span=2 width=73><TBODY>
</TBODY>

 

[NBVC]

It's not really clear what you want.

Are you just looking to relist the values under each header? Are you trying to just sum all the values in the first row? Are you trying to consecutively sum as you copy down a formula?... please elaborate, and perhaps give example of some expected results.

 

[Akashwani]

Hi,

Do any of these work for you?...

Excel Workbook
	A	B	C	D	E	F	G
1	Name	net	Gross	A	B	C	D
2	A	508	-200.129	508	445	17	241
3	C	17	-34.5861	449	359	96	251
4	D	241	-64.784	411	444	89	233
5	A	449	-171.537	397	454	84	229
6	B	445	65.606	402	408	85
7	A	411	-157.414	422		86
8	D	251	-44.4871	450
9	B	359	-22.8478	510
10	C	96	-27.9752
11	A	397	101.685
12	A	402	-152.452
13	C	89	-23.3072
14	A	422	-141.114
15	B	444	51.4022
16	D	233	-33.4352
17	A	450	-91.0501
18	C	84	-16.5229
19	A	510	73.982
20	C	85	-19.5838
21	B	454	-13.6608
22	B	408	-23.8842
23	C	86	-15.9449
24	D	229	-42.8249
Sheet18

Excel Workbook
	A	B	C	D	E	F	G
1	Name	net	Gross	A	B	C	D
2	A	508	-200.129	3549	2110	457	954
3	C	17	-34.5861
4	D	241	-64.784
5	A	449	-171.537
6	B	445	65.606
7	A	411	-157.414
8	D	251	-44.4871
9	B	359	-22.8478
10	C	96	-27.9752
11	A	397	101.685
12	A	402	-152.452
13	C	89	-23.3072
14	A	422	-141.114
15	B	444	51.4022
16	D	233	-33.4352
17	A	450	-91.0501
18	C	84	-16.5229
19	A	510	73.982
20	C	85	-19.5838
21	B	454	-13.6608
22	B	408	-23.8842
23	C	86	-15.9449
24	D	229	-42.8249
Sheet18

Excel Workbook
	A	B	C	D	E	F	G
1	Name	net	Gross	A	B	C	D
2	A	508	-200.129	4287.03	2053.38	594.92	1139.53
3	C	17	-34.5861
4	D	241	-64.784
5	A	449	-171.537
6	B	445	65.606
7	A	411	-157.414
8	D	251	-44.4871
9	B	359	-22.8478
10	C	96	-27.9752
11	A	397	101.685
12	A	402	-152.452
13	C	89	-23.3072
14	A	422	-141.114
15	B	444	51.4022
16	D	233	-33.4352
17	A	450	-91.0501
18	C	84	-16.5229
19	A	510	73.982
20	C	85	-19.5838
21	B	454	-13.6608
22	B	408	-23.8842
23	C	86	-15.9449
24	D	229	-42.8249
Sheet18

I hope that helps.

Ak

 

[grantjw]

AK, Thanks very much. You first response was the one I was looking for, it works perfectly.

 

[Akashwani]

Hi,

Thanks for the feedback, I'm pleased it worked for you.

Ak