Vlookup returns inconsistent results
Vlookup does not return the proper result. The exact value in E80 exists within the specified range, but Vlookup returns a value of zero vs. the expected 18.0603
=IF(E80=D79,"YES","NO") .... Result = TRUE/YES
=VLOOKUP(E80,$D$12:$F79,3,FALSE) .... Result = 0
[F79]=18.0603
[D73] = 9
[D79] = 9.01
Thoughts:
Whole Numbers more robust?
Empty Cells before a non-whole number
Too many logical/reference functions in the worksheet
Too many conditional formatting rules in worksheet
I also varied my reference cell (value and pointer)
The reason, I'm trying to make this work is so I can enable a dynamic look up and rollup calculations when providing an overview of information from this worksheet.
|