close
i cant get vlookup to select the closest value if the closest value is higher
it automatically selects the highest value below the cell value
VLOOKUP() will not do what you want. You can use MATCH() and INDEX(), if the
list is sorted in descending order and you use -1 as the 3rd argument in the
MATCH() functionquot;vlookup help plsquot; wrote:
gt; i cant get vlookup to select the closest value if the closest value is higher
gt; it automatically selects the highest value below the cell value
全站熱搜
留言列表
