CAN DATES BE USED IN LOOKUPS?
 

Hi - I am trying to find a way to bring over data using dates. Can I use a
look up to say 'if you find any date in "cell a"? So far as I can see lookups
and if statements can not be applied to cover any date reference - you have
to specify a particular date.
I currently use a spreadsheet which is updated with the date whenever I
receive either text or images I am waiting for. If nothing has been received
then nothing is put into cell and it remains blank. I need to create a way
for me to quickly look through all the data and return a list of items which
have not been received (hence no date in cell). Can anyone think of a better
way to do this?
Thanks

CAN DATES BE USED IN LOOKUPS?
 

YOu can use a date in a VLOOKUP or HLOOKUP as the date is just a serial
number indicating the number of days elapsed since 1/1/1900.

As for a quick and dirty way to locate items lacking a date, you could sort
the data on the column that has the dates and blank values will appear at the
top.


--
Kevin Backmann


"Riasworld" wrote:

Hi - I am trying to find a way to bring over data using dates. Can I use a
look up to say 'if you find any date in "cell a"? So far as I can see lookups
and if statements can not be applied to cover any date reference - you have
to specify a particular date.
I currently use a spreadsheet which is updated with the date whenever I
receive either text or images I am waiting for. If nothing has been received
then nothing is put into cell and it remains blank. I need to create a way
for me to quickly look through all the data and return a list of items which
have not been received (hence no date in cell). Can anyone think of a better
way to do this?
Thanks