I am trying to make a model/calculator. It should take data from a dropdown and find that data point in a separate column and then return the row data for that column.
For example, I need to add data to the Hosting Cost column. The data inside the cells in this column should change when Tier selection drop down changes. The formula needs to take the tier # selected in the drop down, find that # on the Hosting Cost Table, and return the correct row data for each row. I cannot figure this out to save my life. Embedded the doc here, feel free to add the formula!