I need some help with the following problem:

1. I have built a s/s that analyzes multiple variables (e.g. cost of sales,
SG&A spend, etc.) in a "current state" and "next gen state". The variables
are analyzed for a range of company revenue sizes (e.g. $25M, $25-$100M,
$101-$250M, etc.).
2. Based upon the above data, I would like to populate a s/s with that data,
dependent upon the input from a third party. For example, if the third party
inputs $55M revenues, I would like to populate the sheet with all of the data
related to "current state" and "next gen state" companies between $25-$100M.
The third party input will vary each time that it is entered.

Not sure how to do this and would love some input from anyone who might know.

Thanks!