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.

Attached Files

VLookupExcerpt.xlsx (95.1 KB, 12 views)