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 Ryan,
As variant it could be rounding. Did you try to compare such cells like
=(Avalue=Bvalue)
if it returns TRUE of FALSE?
Hi Sergei,
Thanks for the response. I hadn't thought to try that, I checked manually and the values seem to match.
Just tried your method and it returns TRUE.
When better to have the sample with the formula is not working.
