Vlookup or If statement using date ranges, pull in data if cell is within a range

S

sheahan

New Member
Joined
Jul 18, 2012
Messages
1
I'm trying to automatically populate 4 different tables with data from a single table based on the date in which the description occured. If its in Q1, then put data in Q1 table, etc. I appreciate any ideas you may have

[TABLE="width: 820"]
<TBODY>[TR]
[TD]Date
[/TD]
[TD]team
[/TD]
[TD]description
[/TD]
[TD][/TD]
[TD]Q1</SPAN>
[/TD]
[TD]1/12-3/12</SPAN>
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8/16/12</SPAN>
[/TD]
[TD]<st1:stockticker>ABC</st1:stockticker> </SPAN>
[/TD]
[TD]description 19 entered here</SPAN>
[/TD]
[TD][/TD]
[TD]Date</SPAN>
[/TD]
[TD]Team</SPAN>
[/TD]
[TD]Description</SPAN>
[/TD]
[/TR]
[TR]
[TD]7/28/12</SPAN>
[/TD]
[TD]DEF</SPAN>
[/TD]
[TD]description 18 entered here</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/28/12</SPAN>
[/TD]
[TD]<st1:stockticker>ABC</st1:stockticker> </SPAN>
[/TD]
[TD]description 17 entered here</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/26/12</SPAN>
[/TD]
[TD]<st1:stockticker>ABC</st1:stockticker> </SPAN>
[/TD]
[TD]description 16 entered here</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9/4/12</SPAN>
[/TD]
[TD]DEF</SPAN>
[/TD]
[TD]description 15 entered here</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/14/12</SPAN>
[/TD]
[TD]DEF</SPAN>
[/TD]
[TD]description 14 entered here</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/7/12</SPAN>
[/TD]
[TD]<st1:stockticker>ABC</st1:stockticker> </SPAN>
[/TD]
[TD]description 13 entered here</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/2/12</SPAN>
[/TD]
[TD]DEF</SPAN>
[/TD]
[TD]description 12 entered here</SPAN>
[/TD]
[TD][/TD]
[TD]Q2</SPAN>
[/TD]
[TD]4/12-6/12</SPAN>
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/30/12</SPAN>
[/TD]
[TD]<st1:stockticker>ABC</st1:stockticker> </SPAN>
[/TD]
[TD]description 11 entered here</SPAN>
[/TD]
[TD][/TD]
[TD]Date</SPAN>
[/TD]
[TD]Team</SPAN>
[/TD]
[TD]Description</SPAN>
[/TD]
[/TR]
[TR]
[TD]6/29/12</SPAN>
[/TD]
[TD]<st1:stockticker>ABC</st1:stockticker> </SPAN>
[/TD]
[TD]description 10 entered here</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11/25/12</SPAN>
[/TD]
[TD]DEF</SPAN>
[/TD]
[TD]description 9 entered here</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/22/12</SPAN>
[/TD]
[TD]DEF</SPAN>
[/TD]
[TD]description 8 entered here</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/20/12</SPAN>
[/TD]
[TD]<st1:stockticker>ABC</st1:stockticker> </SPAN>
[/TD]
[TD]description 7 entered here</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12/30/12</SPAN>
[/TD]
[TD]<st1:stockticker>ABC</st1:stockticker> </SPAN>
[/TD]
[TD]description 6 entered here</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/18/12</SPAN>
[/TD]
[TD]<st1:stockticker>ABC</st1:stockticker> </SPAN>
[/TD]
[TD]description 5 entered here</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/17/12</SPAN>
[/TD]
[TD]DEF</SPAN>
[/TD]
[TD]description 4 entered here</SPAN>
[/TD]
[TD][/TD]
[TD]Q3</SPAN>
[/TD]
[TD]7/12-9/12</SPAN>
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/11/12</SPAN>
[/TD]
[TD]DEF</SPAN>
[/TD]
[TD]description 3 entered here</SPAN>
[/TD]
[TD][/TD]
[TD]Date</SPAN>
[/TD]
[TD]Team</SPAN>
[/TD]
[TD]Description</SPAN>
[/TD]
[/TR]
[TR]
[TD]6/6/12</SPAN>
[/TD]
[TD]<st1:stockticker>ABC</st1:stockticker> </SPAN>
[/TD]
[TD]description 2 entered here</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/1/12</SPAN>
[/TD]
[TD]DEF</SPAN>
[/TD]
[TD]description 1 entered here</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/1/12</SPAN>
[/TD]
[TD]DEF</SPAN>
[/TD]
[TD]description 0 entered here</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/9/12</SPAN>
[/TD]
[TD]<st1:stockticker>ABC</st1:stockticker> </SPAN>
[/TD]
[TD]description 20 entered here</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4/7/12</SPAN>
[/TD]
[TD]DEF</SPAN>
[/TD]
[TD]description 21 entered here</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3/8/12</SPAN>
[/TD]
[TD]<st1:stockticker>ABC</st1:stockticker> </SPAN>
[/TD]
[TD]description 22 entered here</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/8/12</SPAN>
[/TD]
[TD]DEF</SPAN>
[/TD]
[TD]description 23 entered here</SPAN>
[/TD]
[TD][/TD]
[TD]Q4</SPAN>
[/TD]
[TD]10/12-12/12</SPAN>
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Date</SPAN>
[/TD]
[TD]Team</SPAN>
[/TD]
[TD]Description</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
You must log in or register to reply here.

Similar threads

S
  • Question Question
VBA code HTML text transformation
Replies
4
Views
206
Sia
S
G
  • Solved
Combined IF/OR statement with the OR based on a group of values in cells
Replies
4
Views
263
Fluff
Fluff
E
  • Question Question
Adding a custom message.
Replies
1
Views
633
Micron
M
F
  • Question Question
Assistance with Runout Dates?
Replies
1
Views
127
Fluff
Fluff
E
  • Question Question
VBA code clean up
Replies
9
Views
482
mumps
mumps

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

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