I have a table of data, which includes miscellaneous figures like salary, revenues etc.
I want to be able to extract data from the salary columns when I enter an approximate revenue figure, that isn't necessarily one that is part of the data. For example, pull the salary data related to 714M in revenue, when I enter 700M.
I tried VLOOKUP but that gives me the closest number that is lower than my reference.
Bookmarks