A1= 2
A2 = 4
A3 = 6
B1 = 3
C1 = has to look through A1, A2, A3 and return the closest larger number (in comparison to B1's 3), in that case return A2 with its 4.
D1 = Needs to do the same thing but return the cell with the closest lower number - in this case A1.
I don't even have an idea how to craft a usable search term for this.
Bookmarks