Beaver2888Copper ContributorFeb 01, 2023Excel cant Lookup only "1.14" I want lookup 1.14 and return "H" but it doesn't work, even use INDEX+MATCH Show More
HansVogelaarMVPFeb 01, 2023Beaver2888 Change the formula in F2 to =ROUND(D2+E2/100,2) Then fill down.
