how do i get excel to use data in a table based on the result of a

[keith metcalfe]

i have a table set up that uses a sales price to caluclate a levy based on
various formula's for 5 ranges. i have then set up a calculation table which
returns a result between 1 and 5 depending on the result of the calculations.
i want to autmatically have that result entered into the table which shows
the selling price in the row next to the selling price, but can't figure a
way to do this, i currently manually enter the cell reference to the result
of the calculation based on the rsult it returns (1-5), any suggestions?

 

[Jacob Skaria]

You can use VLOOKUP() or just the LOOKUP() function. Could you post sample
data so as to suggest the best option..

If this post helps click Yes

 

[Shane Devenshire]

Hi,

We could be more specific if you showed us examples of the data layout and
expected result in any given situation.