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

  • Thread starter Thread starter keith metcalfe
  • Start date Start date
K

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?
 
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
 
Hi,

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