Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,346
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Two-variable Data Table - Problem with result/output Chanpheng Botham Excel Worksheet Functions 1 May 7th 08 10:20 PM
can I get excel to send an email based on a cell result? rasty Excel Discussion (Misc queries) 1 June 7th 07 09:27 AM
What is a result cell in a data table? (Excel) Sarah Excel Discussion (Misc queries) 0 February 15th 06 08:48 AM
vlookup based on random result returns incorrect result rickat Excel Worksheet Functions 1 December 6th 05 02:16 PM
Can Excel operate a function based on a true or false result? SteveD Excel Worksheet Functions 1 August 26th 05 01:47 PM


All times are GMT +1. The time now is 11:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"