Excel MATCH function returns #N/A when dividing lookup value

Asked Apr 22 '23 at 10:08

Active Apr 22 '23 at 10:08

Viewed 27 times

A simple MATCH formula returns #N/A when, strangely, looking up 0.035*100 (= 3.5) in an array which contains 3, 3.5, 4 and 4.5.

This correctly returns 4 when looking up 0.045*100. What's going on here?

Excel 365 version 2393

Expected 2 to be returned.

asked Apr 22 '23 at 10:08

scheherazade

2

Lookup `ROUND(0.035*100, 1)`. – GSerg Apr 22 '23 at 10:31
2

`=MATCH(ROUND(0.035*100, 15),A1:A4,0)` – P.b Apr 22 '23 at 13:12
OK, point taken. Why does =(0.035*100)=3.5 return TRUE though? – scheherazade Apr 24 '23 at 13:01

0 Answers0