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...
Thanks Lloyd. But on my schedule, when I change A4 to a different number, I have a formula in A5-A8 to increase by .1. I can't have text in that column. Row 5 works, why wouldn't the rest? And just for kicks and giggles. I changed it all to text and I get no values showing.
Ok. So I suspect you have a rounding error causing the issue. Whilst keeping your data as numbers, change the vlookup to
=VLOOKUP(TRUNC($A7,2),DB!$A$3:$I$17,2,FALSE)
Also check your ranges - not all your formulae include all your data - some stop at row 14.
Thanks Llyod. Sergie's answer fixed all but one issue. that's the range issue you just pointed out fixed my last issue of program 3! Thank you all. It's working perfectly now!!!!!!!