help with vlookup or index or match or what?

rcirone

Active Member
Joined
Mar 12, 2009
Messages
483
Office Version
  1. 365
Platform
  1. Windows
I have 4 taps
1. Two-Ten tab
2. Loc tab
3. Purple Tap
4. Data Dump Tab
I am try get the info from data dump tab to all the other taps with the right Program. if you look at the pic you will see what I need to do please help I do not know if I use vlookup index or what?
Sorry but I can not change the order of the data dunp Tab.
Please Help?
work1.jpg
 
I think i get whats going on, I can do this via VBA if you can put the data dump in its own tab. Are these all setup as tables?
 
Last edited:
Upvote 0
Maybe this:

Array formula - use Ctrl+Shift+Enter and not only Enter to enter the formula

Code:
=IFERROR(INDEX('Data Dump'!$A$2:$L$8,
SMALL(IF('Data Dump'!$D$2:$D$8=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,99),ROW('Data Dump'!$D$2:$D$8)-ROW('Data Dump'!$D$2)+1),ROWS(A$2:A2)),
COLUMNS($A2:A2)),"")

PS: use the same formula in each sheet (Purple,LOC and Two-Ten)

Markmzz
 
Upvote 0
It's not clear at all to me what you want to happen, to what and to where or why.

What info from data dump do you want to go to other tabs and how does one know what tab the information is to go to that tab.

...other taps with the right Program. What does this mean?

Maybe pick a name in data dump and explain clearly what you want to happen to that name and associated info on that row.

Regards,
Howard
 
Upvote 0
I think i get whats going on, I can do this via VBA if you can put the data dump in its own tab. Are these all setup as tables?

Yes all yellow tab are there own tab I just put it this way so you can all see what I need.
 
Upvote 0
I am looking to get the info from the data dump tab to the other yellow tabs. each of the yellow tabs are there own tabs. So I am looking to get the info from the data dump taps (under two-ten program to goto it own tab. so all I have to do is to copy and paste the data in and all the tabs with auto work like two-ten tab, loc tab, purple tab etc.....
 
Upvote 0
The easiest way to do this IMO is using the following logic with VBA

For each row in data dump table, minus the header row
Determine what the current row's program is
Then for each cell in that row, write it to the correct sheet.

In order to do this, I will need to know what your entire data dump looks like. How many columns, what are they called, what kind of data do they hold, what formula do you use in each calculated cell already, etc.
 
Upvote 0
Maybe this:

Array formula - use Ctrl+Shift+Enter and not only Enter to enter the formula

Code:
=IFERROR(INDEX('Data Dump'!$A$2:$L$8,
SMALL(IF('Data Dump'!$D$2:$D$8=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,99),ROW('Data Dump'!$D$2:$D$8)-ROW('Data Dump'!$D$2)+1),ROWS(A$2:A2)),
COLUMNS($A2:A2)),"")

PS: use the same formula in each sheet (Purple,LOC and Two-Ten)

Markmzz

Hi Rcirone,

Did you try my formula of the post #3 (the above formula)?

If yes, what you got?

Here is the result with my sample workbook

[TABLE="width: 482"]
<tbody>[TR]
[TD="class: xl63, width: 64, bgcolor: transparent"]Agent Name
[/TD]
[TD="class: xl63, width: 31, bgcolor: transparent"]E#
[/TD]
[TD="class: xl63, width: 87, bgcolor: transparent"]Supervisor Name
[/TD]
[TD="class: xl63, width: 47, bgcolor: transparent"]Program
[/TD]
[TD="class: xl63, width: 49, bgcolor: transparent"]Phone
[/TD]
[TD="class: xl63, width: 28, bgcolor: transparent"]True
[/TD]
[TD="class: xl63, width: 49, bgcolor: transparent"]Total
[/TD]
[TD="class: xl63, width: 58, bgcolor: transparent"]Productive
[/TD]
[TD="class: xl63, width: 42, bgcolor: transparent"]Lunch
[/TD]
[TD="class: xl63, width: 42, bgcolor: transparent"]Non-
[/TD]
[TD="class: xl63, width: 42, bgcolor: transparent"]Talk
[/TD]
[TD="class: xl63, width: 42, bgcolor: transparent"]Calls
[/TD]
[TD="class: xl64, width: 58, bgcolor: transparent"]Data Dump
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Name01
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]2608
[/TD]
[TD="class: xl63, bgcolor: transparent"]Name10
[/TD]
[TD="class: xl63, bgcolor: transparent"]Purple
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]08:33:39
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]176
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]23:11:20
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data01
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data07
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data13
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data19
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data25
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Name02
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]2235
[/TD]
[TD="class: xl63, bgcolor: transparent"]Name11
[/TD]
[TD="class: xl63, bgcolor: transparent"]Two-Ten
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]23:34:11
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]278
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]13:58:13
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data02
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data08
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data14
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data20
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data26
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Name03
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]8618
[/TD]
[TD="class: xl63, bgcolor: transparent"]Name12
[/TD]
[TD="class: xl63, bgcolor: transparent"]Two-Ten
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]21:43:06
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]275
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]19:51:27
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data03
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data09
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data15
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data21
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data27
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Name04
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]2146
[/TD]
[TD="class: xl63, bgcolor: transparent"]Name13
[/TD]
[TD="class: xl63, bgcolor: transparent"]Two-Ten
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]23:02:37
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]162
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]06:51:07
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data04
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data10
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data16
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data22
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data28
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Name05
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]8976
[/TD]
[TD="class: xl63, bgcolor: transparent"]Name14
[/TD]
[TD="class: xl63, bgcolor: transparent"]LOC
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]12:03:53
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]282
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]02:16:39
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data05
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data11
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data17
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data23
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data29
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Name06
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]8239
[/TD]
[TD="class: xl63, bgcolor: transparent"]Name15
[/TD]
[TD="class: xl63, bgcolor: transparent"]LOC
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]17:14:44
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]202
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]03:37:44
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data06
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data12
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data18
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data24
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data30
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Name07
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]8425
[/TD]
[TD="class: xl63, bgcolor: transparent"]Name16
[/TD]
[TD="class: xl63, bgcolor: transparent"]Two-Ten
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]01:37:11
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]299
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]05:15:56
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data07
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data13
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data19
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data25
[/TD]
[TD="class: xl63, bgcolor: transparent"]Data31
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]*
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Agent Name
[/TD]
[TD="class: xl63, bgcolor: transparent"]E#
[/TD]
[TD="class: xl63, bgcolor: transparent"]Supervisor Name
[/TD]
[TD="class: xl63, bgcolor: transparent"]Program
[/TD]
[TD="class: xl63, bgcolor: transparent"]Phone
[/TD]
[TD="class: xl63, bgcolor: transparent"]True
[/TD]
[TD="class: xl63, bgcolor: transparent"]Total
[/TD]
[TD="class: xl63, bgcolor: transparent"]Productive
[/TD]
[TD="class: xl63, bgcolor: transparent"]Lunch
[/TD]
[TD="class: xl63, bgcolor: transparent"]Non-
[/TD]
[TD="class: xl63, bgcolor: transparent"]Talk
[/TD]
[TD="class: xl63, bgcolor: transparent"]Calls
[/TD]
[TD="class: xl64, bgcolor: transparent"]Two-Ten
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: yellow"]Name02
[/TD]
[TD="class: xl66, bgcolor: yellow, align: right"]2235
[/TD]
[TD="class: xl66, bgcolor: yellow"]Name11
[/TD]
[TD="class: xl66, bgcolor: yellow"]Two-Ten
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]23:34:11
[/TD]
[TD="class: xl66, bgcolor: yellow, align: right"]278
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]13:58:13
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data02
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data08
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data14
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data20
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data26
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: yellow"]Name03
[/TD]
[TD="class: xl66, bgcolor: yellow, align: right"]8618
[/TD]
[TD="class: xl66, bgcolor: yellow"]Name12
[/TD]
[TD="class: xl66, bgcolor: yellow"]Two-Ten
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]21:43:06
[/TD]
[TD="class: xl66, bgcolor: yellow, align: right"]275
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]19:51:27
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data03
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data09
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data15
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data21
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data27
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: yellow"]Name04
[/TD]
[TD="class: xl66, bgcolor: yellow, align: right"]2146
[/TD]
[TD="class: xl66, bgcolor: yellow"]Name13
[/TD]
[TD="class: xl66, bgcolor: yellow"]Two-Ten
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]23:02:37
[/TD]
[TD="class: xl66, bgcolor: yellow, align: right"]162
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]06:51:07
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data04
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data10
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data16
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data22
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data28
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: yellow"]Name07
[/TD]
[TD="class: xl66, bgcolor: yellow, align: right"]8425
[/TD]
[TD="class: xl66, bgcolor: yellow"]Name16
[/TD]
[TD="class: xl66, bgcolor: yellow"]Two-Ten
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]01:37:11
[/TD]
[TD="class: xl66, bgcolor: yellow, align: right"]299
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]05:15:56
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data07
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data13
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data19
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data25
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data31
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]*
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Agent Name
[/TD]
[TD="class: xl63, bgcolor: transparent"]E#
[/TD]
[TD="class: xl63, bgcolor: transparent"]Supervisor Name
[/TD]
[TD="class: xl63, bgcolor: transparent"]Program
[/TD]
[TD="class: xl63, bgcolor: transparent"]Phone
[/TD]
[TD="class: xl63, bgcolor: transparent"]True
[/TD]
[TD="class: xl63, bgcolor: transparent"]Total
[/TD]
[TD="class: xl63, bgcolor: transparent"]Productive
[/TD]
[TD="class: xl63, bgcolor: transparent"]Lunch
[/TD]
[TD="class: xl63, bgcolor: transparent"]Non-
[/TD]
[TD="class: xl63, bgcolor: transparent"]Talk
[/TD]
[TD="class: xl63, bgcolor: transparent"]Calls
[/TD]
[TD="class: xl64, bgcolor: transparent"]LOC
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: yellow"]Name05
[/TD]
[TD="class: xl66, bgcolor: yellow, align: right"]8976
[/TD]
[TD="class: xl66, bgcolor: yellow"]Name14
[/TD]
[TD="class: xl66, bgcolor: yellow"]LOC
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]12:03:53
[/TD]
[TD="class: xl66, bgcolor: yellow, align: right"]282
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]02:16:39
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data05
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data11
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data17
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data23
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data29
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: yellow"]Name06
[/TD]
[TD="class: xl66, bgcolor: yellow, align: right"]8239
[/TD]
[TD="class: xl66, bgcolor: yellow"]Name15
[/TD]
[TD="class: xl66, bgcolor: yellow"]LOC
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]17:14:44
[/TD]
[TD="class: xl66, bgcolor: yellow, align: right"]202
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]03:37:44
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data06
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data12
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data18
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data24
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data30
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]*
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Agent Name
[/TD]
[TD="class: xl63, bgcolor: transparent"]E#
[/TD]
[TD="class: xl63, bgcolor: transparent"]Supervisor Name
[/TD]
[TD="class: xl63, bgcolor: transparent"]Program
[/TD]
[TD="class: xl63, bgcolor: transparent"]Phone
[/TD]
[TD="class: xl63, bgcolor: transparent"]True
[/TD]
[TD="class: xl63, bgcolor: transparent"]Total
[/TD]
[TD="class: xl63, bgcolor: transparent"]Productive
[/TD]
[TD="class: xl63, bgcolor: transparent"]Lunch
[/TD]
[TD="class: xl63, bgcolor: transparent"]Non-
[/TD]
[TD="class: xl63, bgcolor: transparent"]Talk
[/TD]
[TD="class: xl63, bgcolor: transparent"]Calls
[/TD]
[TD="class: xl64, bgcolor: transparent"]Purple
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: yellow"]Name01
[/TD]
[TD="class: xl66, bgcolor: yellow, align: right"]2608
[/TD]
[TD="class: xl66, bgcolor: yellow"]Name10
[/TD]
[TD="class: xl66, bgcolor: yellow"]Purple
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]08:33:39
[/TD]
[TD="class: xl66, bgcolor: yellow, align: right"]176
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]23:11:20
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data01
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data07
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data13
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data19
[/TD]
[TD="class: xl66, bgcolor: yellow"]Data25
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]************
[/TD]
[TD="class: xl63, bgcolor: transparent"]*****
[/TD]
[TD="class: xl63, bgcolor: transparent"]*****************
[/TD]
[TD="class: xl63, bgcolor: transparent"]********
[/TD]
[TD="class: xl63, bgcolor: transparent"]*********
[/TD]
[TD="class: xl63, bgcolor: transparent"]*****
[/TD]
[TD="class: xl63, bgcolor: transparent"]*********
[/TD]
[TD="class: xl63, bgcolor: transparent"]***********
[/TD]
[TD="class: xl63, bgcolor: transparent"]********
[/TD]
[TD="class: xl63, bgcolor: transparent"]*******
[/TD]
[TD="class: xl63, bgcolor: transparent"]*******
[/TD]
[TD="class: xl63, bgcolor: transparent"]*******
[/TD]
[TD="class: xl63, bgcolor: transparent"]***********
[/TD]
[/TR]
</tbody>[/TABLE]


Markmzz
 
Upvote 0
if this is an one-off exercise, you may consider to use Advance Filter. Quick and easy and no Formula is required.


I have 4 taps
1. Two-Ten tab
2. Loc tab
3. Purple Tap
4. Data Dump Tab
I am try get the info from data dump tab to all the other taps with the right Program. if you look at the pic you will see what I need to do please help I do not know if I use vlookup index or what?
Sorry but I can not change the order of the data dunp Tab.
Please Help?
work1.jpg
 
Upvote 0
I have 4 taps
1. Two-Ten tab
2. Loc tab
3. Purple Tap
4. Data Dump Tab
I am try get the info from data dump tab to all the other taps with the right Program. if you look at the pic you will see what I need to do please help I do not know if I use vlookup index or what?
Sorry but I can not change the order of the data dunp Tab.
Please Help?
...

Activate Two-Ten tab.

Row 1 is supposed to have the headers in the same order as Data Dump tab.

Add an extra column in front of the current first column. The headers start now at B1.

In A1 enter: Idx, which is an additional headers.

A2, control+shift+enter, not just enter, and copy down:
Rich (BB code):
=IFERROR(SMALL(IF('Data Dump tab'!$D$2:$D$100="Two-Ten",
  ROW('Data Dump tab'!$D$2:$D$100)-ROW('Data Dump tab'!$D$2)+1),
  ROWS($A$2:A2)),"")

B2, just enter, copy across, and down:
Rich (BB code):
=IF($A2="","",INDEX('Data Dump tab'!A$2:A$100,$A2))

The foregoing is the fastest set up we can have. Adjust to suit and repeat it for the other tabs.
 
Upvote 0

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