Lookup unsorted names and return only value associated with name

G

grantjw

New Member
Joined
Dec 17, 2012
Messages
12
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!

[TABLE="width: 358"]
<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>[TR]
[TD="class: xl28, width: 64, bgcolor: transparent"]Name[/TD]
[TD="class: xl28, width: 64, bgcolor: transparent"]net[/TD]
[TD="class: xl28, width: 69, bgcolor: transparent"]Gross[/TD]
[TD="class: xl28, width: 64, bgcolor: transparent"]A[/TD]
[TD="class: xl28, width: 69, bgcolor: transparent"]B[/TD]
[TD="class: xl28, width: 73, bgcolor: transparent"]C[/TD]
[TD="class: xl28, width: 73, bgcolor: transparent"]D[/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]A[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]508[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]-200.129[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]C[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]17[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]-34.5861[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]D[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]241[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]-64.784[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]A[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]449[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]-171.537[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]B[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]445[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]65.606[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]A[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]411[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]-157.414[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]D[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]251[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]-44.4871[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]B[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]359[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]-22.8478[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]C[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]96[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]-27.9752[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]A[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]397[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]101.685[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]A[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]402[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]-152.452[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]C[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]89[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]-23.3072[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]A[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]422[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]-141.114[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]B[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]444[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]51.4022[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]D[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]233[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]-33.4352[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]A[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]450[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]-91.0501[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]C[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]84[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]-16.5229[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]A[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]510[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]73.982[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]C[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]85[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]-19.5838[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]B[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]454[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]-13.6608[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]B[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]408[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]-23.8842[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]C[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]86[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]-15.9449[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: white"]D[/TD]
[TD="class: xl25, width: 64, bgcolor: white"]229[/TD]
[TD="class: xl25, width: 69, bgcolor: white"]-42.8249[/TD]
[TD="class: xl26, width: 64, bgcolor: white"] [/TD]
[TD="class: xl25, width: 69, bgcolor: white"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[TD="class: xl27, width: 73, bgcolor: transparent"] [/TD]
[/TR]
</TBODY>[/TABLE]
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Sort by date Sort by votes
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.
 
Upvote 0
Hi,

Do any of these work for you?...

Excel Workbook
ABCDEFG
1NamenetGrossABCD
2A508-200.12950844517241
3C17-34.586144935996251
4D241-64.78441144489233
5A449-171.53739745484229
6B44565.60640240885
7A411-157.41442286
8D251-44.4871450
9B359-22.8478510
10C96-27.9752
11A397101.685
12A402-152.452
13C89-23.3072
14A422-141.114
15B44451.4022
16D233-33.4352
17A450-91.0501
18C84-16.5229
19A51073.982
20C85-19.5838
21B454-13.6608
22B408-23.8842
23C86-15.9449
24D229-42.8249
Sheet18


Excel Workbook
ABCDEFG
1NamenetGrossABCD
2A508-200.12935492110457954
3C17-34.5861
4D241-64.784
5A449-171.537
6B44565.606
7A411-157.414
8D251-44.4871
9B359-22.8478
10C96-27.9752
11A397101.685
12A402-152.452
13C89-23.3072
14A422-141.114
15B44451.4022
16D233-33.4352
17A450-91.0501
18C84-16.5229
19A51073.982
20C85-19.5838
21B454-13.6608
22B408-23.8842
23C86-15.9449
24D229-42.8249
Sheet18


Excel Workbook
ABCDEFG
1NamenetGrossABCD
2A508-200.1294287.032053.38594.921139.53
3C17-34.5861
4D241-64.784
5A449-171.537
6B44565.606
7A411-157.414
8D251-44.4871
9B359-22.8478
10C96-27.9752
11A397101.685
12A402-152.452
13C89-23.3072
14A422-141.114
15B44451.4022
16D233-33.4352
17A450-91.0501
18C84-16.5229
19A51073.982
20C85-19.5838
21B454-13.6608
22B408-23.8842
23C86-15.9449
24D229-42.8249
Sheet18


I hope that helps.

Ak
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
Add Sequence numbers Based on Dates
Replies
1
Views
3K
Jeffrey Mahoney
Jeffrey Mahoney
H
  • Question Question
Macros - Auto Copy paste row when cell value changes
Replies
7
Views
6K
Fluff
Fluff
N
  • Question Question
sorting to other worksheets
Replies
6
Views
1K
NatureGreen
N
N
  • Question Question
Multiple condition lookup
Replies
5
Views
677
navi_jen
N
H
  • Question Question
comparing values in a column against multiple sheets and returning subsequent values from other columns
Replies
1
Views
1K
DanteAmor
DanteAmor

Forum statistics

Threads
1,223,243
Messages
6,170,967
Members
452,371
Latest member
Frana

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top