Forum Discussion
Solved
Need help DESPERATELY. Ready to give up ! vlookup
Enclosed is my spreadsheet to total add all feet, inches and fractions. Then convert them all back to Feet, Inches and Fractions The table VLOOKUP function looks at the value in cell F14 "fa...
I STAND CORRECTED! Used the formula
=IF(FRACTION=0,"0",VLOOKUP(FRACTION,RANGE,2)) WORKS PERFECT !!!
Finally thanks to your help!
Thanks but i have never used that function.
If possible could please give me an example as it pertains to my spreadsheet.
Thank You!
See attached file.
Using CONVERT() also means you can get rid of your helper table and your rounding problem.