I am trying to do a lookup across twp worksheets to return a value between 0.00 and 1.00, however the formula is not returning decimal places i.e 0.81.
=VLOOKUP(A66,Sheet3!A65 4684,12)
Both tables are sorted in order and referencing right column etc also tried using False.
Have you tried formatting the cell where the vlookup formula is located as a number with two decimal places?
Post some data and expected results but I'm thinking you may be able to incorporate the ROUND function in somewhere
HTH
I can't tell if this is the problem you are having, but have a look at this thread with the explanation I provided:
board2/viewto...404amp;highlight= |
Post at 2011-4-21 08:49
| This Author's Posts Only
