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...
Hi Dan,
You can try to copy the values from tabsheet 'Sch' to tabsheet 'DB'. Problably the 2,3 is not exactly the same in both tabsheets.
Kr
TK
You can try to copy the values from tabsheet 'Sch' to tabsheet 'DB'. Problably the 2,3 is not exactly the same in both tabsheets.
Kr
TK
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
Sorry Sergei, I missed your first suggestion.
Thanks! That worked!!!!!
