Forum Discussion
Vlookup not working properly
I'm a novice user, and this is my first post, so not sure i'm even doing this right. I feel I have my formulas right and Vlookup is not pulling the info.
I have a schedule where depending on t...
I that's how I created the fields. It still won't work
Dan, that's binary representation. If you try
=VLOOKUP((2.1+0.1),DB!$A$3:$G$16,2,FALSE)
works,
=VLOOKUP((2.2+0.1),DB!$A$3:$G$16,2,FALSE)
doesn't work, but
=VLOOKUP(2.3,DB!$A$3:$G$16,2,FALSE)
works
I'd suggest to round as in previous post