Lookup Help

DRExcel515

Board Regular
Joined
Oct 20, 2017
Messages
56
I have a tab in a spreadsheet that each month gets a brand new dump of data for 3 different mutual funds. For the month ending 11.30.17 the total number of holdings for all 3 funds was 533 and for 12.31.17 was 544 (they are listed in order... so all of one funds holdings are from say row 2-100, then fund 3 and so on all the way down). My point is that the total number of individual holdings and total rows of data changes each month.

I have separate tabs for each of the 3 funds that each month I make a copy of the tab and copy and paste the new set of holdings into the respective funds new month end tab. What I'd love to be able to do is have a formula that somehow goes into the tab that gets the new holdings for each fund dumped in every month and somehow pulls over the correct list of holdings for that fund (even if say one month one of the funds has 100 holdings and ends on row 100 and the next month has 88 holdings and ends on row 88). The example below is say where I would dump the holdings for the 3 funds each month. There are 3 separate tabs (one for each fund that would need to find all the holdings for each fund. Any help would be much appreciated:)

[TABLE="width: 280"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Fund Code[/TD]
[TD]Holding[/TD]
[/TR]
[TR]
[TD]CRO[/TD]
[TD]Holding A[/TD]
[/TR]
[TR]
[TD]CRO[/TD]
[TD]Holding B[/TD]
[/TR]
[TR]
[TD]CRO[/TD]
[TD]Holding C[/TD]
[/TR]
[TR]
[TD]CRO[/TD]
[TD]Holding D[/TD]
[/TR]
[TR]
[TD]ICO[/TD]
[TD]Holding A[/TD]
[/TR]
[TR]
[TD]ICO[/TD]
[TD]Holding B[/TD]
[/TR]
[TR]
[TD]ICO[/TD]
[TD]Holding C[/TD]
[/TR]
[TR]
[TD]ICO[/TD]
[TD]Holding D[/TD]
[/TR]
[TR]
[TD]ICO[/TD]
[TD]Holding E[/TD]
[/TR]
[TR]
[TD]NPT[/TD]
[TD]Holding A[/TD]
[/TR]
[TR]
[TD]NPT[/TD]
[TD]Holding B[/TD]
[/TR]
[TR]
[TD]NPT[/TD]
[TD]Holding C[/TD]
[/TR]
[TR]
[TD]NPT[/TD]
[TD]Holding D[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
In order to make a formula, we would have to know what the names of the tabs are, and what columns all the information is in, and where they are going.
( More info may be needed as well )
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,323
Members
452,635
Latest member
laura12345

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