Vlookup on a percentages, as opposed to a word/text

Topic

New Reply

Hello… I have a vlookup formula (see attached) that is not showing the correct result. I’m looking up a percentage. I’ve used vlookup’s for years, and have never had this problem. Apparently I haven’t been looking up a “percentage”… usually I’m looking up a word (text). Can anyone tell me why this is not working, and how I can get it to work. Any help is much appreciated.
Thanks!
Lana

Reply | Quote

Replies

Try this in D7 and copy down…..
=ROUND(D6+$D$2,4)

Reply | Quote

Of course! Rounding… now I feel really dumb. I round everything else in my worksheets, but I falied to do so in this table! Thanks so much for opening my eyes tfspry! I must have been sleeping!
Lana

Reply | Quote

Lana – You are very welcome. Thanks for posting back!

Reply | Quote