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!
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!
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!
It depends on what you'd like to receive. With aproximate search you have closest value before searched one. With exact search you may wrap your formula with IFNA and return any value you'd like for such case, e.g.
=IFNA(<your formula>, 0)