Quote Originally Posted by Ace_XL View Post
The range that you are looking up from is rounded to 3 decimal places only. Hence, use the below

=VLOOKUP(ROUND(R26,3), $AC$19:$AD$534,2,FALSE)
Thank you, much appreciated