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

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?

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

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
---------------
Jacob Skaria


"keith metcalfe" wrote:

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?

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

Hi,

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"keith metcalfe" wrote:

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?