Hi,
I am having an issue with Vlookup and would really appreciate some help.
When using the Vlookup function I keep getting random #N/A errors. The lookup value is referring to a cell that is a "sum" of several cells. It works sometimes but other times it throws a #N/A error. When I replace the value with the same exact number it works.
For example:
-A1 is the lookup value (7.20)
-A1 references F14
-F14 =SUM(F1:F13); which is 7.20
-B2 is the Vlookup function and the lookup value =A1 but is throwing the #N/A error.
-When I replace A1 with the actual number 7.20 it works just fine.
Please see attached and thank you for your time!
Bookmarks