VLookup returning incorrect results

The problem is that the list is not in an increasing order so at line 127 you have 24.02 and then numbers <= to that until you reach line 139.  I wasn't able to recreate your problem in my 365 account/version as all 3 options: Lookup, VLookup, and XLookup worked 'correctly':

but basically each of the answers you listed were the first case that the value was <= the target value and the next line had a value > the target.  In some ways you are lucky it was even that 'clean' because the search paradigm could also find 'local solutions' in the middle of the list.  If you use XLOOKUP you have options and it will more accurately/reliably find what you want (the option I show in column N).  But assuming you do NOT have 365 or access to these new functions then I suggest you make it find the EXACT match (i.e. do NOT add 0.01).  I'm not sure why you are adding 0.01 but if it is due to some roundoff/decimal places you might need to ROUND( 'FA Devices'!$B$8:$B$710,2)