Variable input to populate data fields

[Guest]

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!

 

[Paul Sheppard]

I need some help with the following problem:

1. I have built a s/s that analyzes multiple variables (e.g. cost o
sales,
SG&A spend, etc.) in a "current state" and "next gen state". Th
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 tha
data,
dependent upon the input from a third party. For example, if the thir
party
inputs $55M revenues, I would like to populate the sheet with all o
the data
related to "current state" and "next gen state" companies betwee
$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 migh
know.

Thanks!

Hi csinvestor

Try creating a lookup table, then use the VLOOKUP or HLOOKUP function

 

[Guest]

Thanks, Paul. However, I still need to address the fact that I will have
variable inputs. For example, if someone enters $55M revenues, I will need
to automatically look up the corresponding values for "current state" and
"next gen state" for the range associated with $55M revenues, or $25-$100M
revenues. Unfortunately, I will not know what someone is going to input
prior to their inputting it.

What syntax would you suggest to address this?

 

[Paul Sheppard]

Thanks, Paul. However, I still need to address the fact that I will
have
variable inputs. For example, if someone enters $55M revenues, I will
need
to automatically look up the corresponding values for "current state"
and
"next gen state" for the range associated with $55M revenues, or
$25-$100M
revenues. Unfortunately, I will not know what someone is going to
input
prior to their inputting it.

What syntax would you suggest to address this?

Hi csinvestor

Assuming the third party inputs to be increments of a million builsd
the lookup table in $1m increments, with $1m-$24m having exactly the
same values for current state and next gen state, then repeat
$25m-$100m etc