ExcelBanter - vlookup using dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - vlookup using dates (https://www.excelbanter.com/excel-programming/390240-vlookup-using-dates.html)

vlookup using dates

User trying to find the value on a certain date can enter that date (a1).
vlookup will search column A for the requested date and then return the
associated value that is in column b.... Column A10:a100 = dates. Column
B10:b100= values... =vlookup(a1,a10:b100,2) returns #N/A

Gary''s Student

vlookup using dates

#N/A means VLOOKUP can't find the matching date.

The date might not be in the table
The date in A1 or the dates in the table might not be true dates
(toggle CNTRL-~ to find out)
--
Gary''s Student - gsnu200725

All times are GMT +1. The time now is 12:00 PM.