Forum Discussion
Selecting the closest value when using the function XlOOKUP
in first table there are numbers: 14.7 13.9 17.2 For numbers from the first table need to find the closest values from the other table where the numbers are 15 14 17 In the XLOOKUP functions, you c...
You may try simple LOOKUP()
as
=LOOKUP(2,1/(MIN(ABS($B$3:$B$5-E3))=ABS($B$3:$B$5-E3)),$C$3:$C$5)