Forum Discussion
Solved
Formula help ISNA MATCH VLOOKUP
Hi. I'm on a PC (Win10) using Excel for 365 MSO ( 16.0.13426.20524, 64-bit) This formula in 2019 worked to add zeroes to empty spots in my data. Now it does not. What gives? =IF(ISNA(MATCH(...
That's the famous floating point error.
Change the formula in column to:
=ROUND(D2+0.000074,6)
=XLOOKUP(D2,$A$2:$A$355,$B$2:$B$355,0)Thanks for the response.
Your formula was successful for some rows, but did not transfer column B values for many other rows, inserting zeroes where there should be nonzero values (see attached). Any ideas?
That's the famous floating point error.
Change the formula in column to:
=ROUND(D2+0.000074,6)- Solved! Thank you kindly
