D
Dale G
Is it possible to set a VLOOKUP to retrieve values using a Date, then setting
the date cell to =NOW(), then retain those values after the date.
For example, I have a workbook that is used to keep track of arrivel times
at a set location. Every sheet in the wookbook is the same location, one
sheet for each day of the month. Column B has the vehicle numbers use on a
specific day. Each day the drivers use a different vehicle.
The vehicles are entered in a feeder sheet each day in a different workbook.
My idea is to have column B of the location workbook retrieve the vehicle
numbers on the date the location sheet is being used.
So far this is all I have in column B.
=IF($A$1=DATE(2009,12,1),VLOOKUP(A3,Feeder!$F$2:$G$121,2,0),"")
is it possible to set A1 to NOW() and still retrieve the vehicle numbers?
Any help is appreciated.
the date cell to =NOW(), then retain those values after the date.
For example, I have a workbook that is used to keep track of arrivel times
at a set location. Every sheet in the wookbook is the same location, one
sheet for each day of the month. Column B has the vehicle numbers use on a
specific day. Each day the drivers use a different vehicle.
The vehicles are entered in a feeder sheet each day in a different workbook.
My idea is to have column B of the location workbook retrieve the vehicle
numbers on the date the location sheet is being used.
So far this is all I have in column B.
=IF($A$1=DATE(2009,12,1),VLOOKUP(A3,Feeder!$F$2:$G$121,2,0),"")
is it possible to set A1 to NOW() and still retrieve the vehicle numbers?
Any help is appreciated.