Forum Discussion
VLOOKUP #N/A Error
Using VLOOKUP to match Date & Time (format dd/mm/yyyy hh:mm) to another date and time (Column A) in the same format and return a value in Column B.
Formula is returning a Value Not Available Er...
Hi,
Maybe the dates in one of the date columns are not real dates, it's may be treated as texts!
Please provide us with a sample of these dates in an attached workbook!
Hi Haytham,
Thanks for the response.
Yes, I checked that and they are definitely dates. Exactly the same Custom formatting.
I will attached one when I get a chance.