D
Daniel Q.
im trying to use vlookups, match and index but the more i work with them the
more confused i get.
i have a "database" setup in one worksheet. I put an IF statement that says
that if i enter info with today's date A1 will give me "NEW", if not "OLD".
On the second worksheet i would like the formula to go to the "db" (array)
and look for any that say "new" and give me values from certain cells
(vlookup?).
For example, i would like the formula to just give me info from Columns C-F
and Rows 7-9.
DB Worksheet
A B C D E F
1 Old/New Date State City Volume Giving Month
2 OLD 15-Apr TX Hou 30000 Apr
3 OLD 15-Apr TX Dal 1500 Apr
4 OLD 15-Apr CA San Die 2000 Apr
5 OLD 15-Apr ND Fargo 2500 Apr
7 NEW 16-Apr CA LA 6000 Apr
8 NEW 16-Apr TX San Ant 1000 Apr
9 NEW 16-Apr TX Austin 7000 Apr
Thanks for all your help in advance!!
more confused i get.
i have a "database" setup in one worksheet. I put an IF statement that says
that if i enter info with today's date A1 will give me "NEW", if not "OLD".
On the second worksheet i would like the formula to go to the "db" (array)
and look for any that say "new" and give me values from certain cells
(vlookup?).
For example, i would like the formula to just give me info from Columns C-F
and Rows 7-9.
DB Worksheet
A B C D E F
1 Old/New Date State City Volume Giving Month
2 OLD 15-Apr TX Hou 30000 Apr
3 OLD 15-Apr TX Dal 1500 Apr
4 OLD 15-Apr CA San Die 2000 Apr
5 OLD 15-Apr ND Fargo 2500 Apr
7 NEW 16-Apr CA LA 6000 Apr
8 NEW 16-Apr TX San Ant 1000 Apr
9 NEW 16-Apr TX Austin 7000 Apr
Thanks for all your help in advance!!