Forum Discussion
How to match a list of values to values from a predetermined list
Hi there, For my thesis I need to do some data cleaning and I'm looking for a way to not have to do this by hand (tens of columns and hundreds of rows). The data I have needs to match a prespecif...
jasper1995 Here's a formula that will return the closes match in the reference list which is larger than the value looking up (column B below).
=INDEX($A$3:$A$18,MATCH(IF(B15>256,256,B15),$A$3:$A$18,-1),1)
Hope this helps.
Dexter
Thank you for the advice! Unfortunately as the other commenter said this still renders the next value up from, and not the nearest one.
EDIT: it works, but when inserting a value of say 0,061 it wil render 0,13 instead of 0,06.