Thread
:
Lookup closest number in list
View Single Post
#
4
tjtjjtjt
Posts: n/a
Forgot to Add, VLOOKUP will always returns the biggest value in Column B that
is still smaller than your LOOKUP value.
See:
http://www.contextures.com/xlFunctions02.html
For more details.
tj
Reply With Quote