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!
Your VLOOKUP is incorrect here
=IF(FRACTION=0,"0",VLOOKUP(RANGE,2,))
if change the syntax on
=IF(FRACTION=0,"0",VLOOKUP(FRACTION,RANGE,2))
it works
I STAND CORRECTED! Used the formula
| =IF(FRACTION=0,"0",VLOOKUP(FRACTION,RANGE,2)) |
WORKS PERFECT !!!
Finally thanks to your help!