Forum Discussion
Need help DESPERATELY. Ready to give up ! vlookup
I STAND CORRECTED! Used the formula
=IF(FRACTION=0,"0",VLOOKUP(FRACTION,RANGE,2)) WORKS PERFECT !!!
Finally thanks to your help!
Thank you for the formula, I appreciate any help.
I still have 1 problem (sorry)
The vlookup function always picks a row above the stated lookup value.
IF if i input a fraction into column F example, input 1/2" it always returns one row above as 7/16"
And yes i tried change to FALSE for an exact match and get a #N/A.
Sorry but i have been working on this for a very long time, on & off.
I sure would like to put this to bed.
Thanks again
Oops, the issue is another - your range is calculated and you have rounding error, thus no exact match. As variant you may correct the formula to
=VLOOKUP(ROUND(FRACTION,6),ROUND(RANGE,6),2)
(see in J15)
VERY close but no cigar.
Tried the example as above & get a #VALUE! error.
The previous formula works awesome, =VLOOKUP(FRACTION,RANGE,2,TRUE)
EXCEPT
The only error i get if my input area is completely BLANK. then i get a #N/A
If there is only 1 piece of data input it works. Range from C5 to F12.
Not a big game changer, just a small annoyance. Otherwise all is correct.
I do want to THANK YOU VERY MUCH for you taking the time to help me with this problem.
I really appreciate it
THANK YOU!