Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two-variable Data Table - Problem with result/output | Excel Worksheet Functions | |||
can I get excel to send an email based on a cell result? | Excel Discussion (Misc queries) | |||
What is a result cell in a data table? (Excel) | Excel Discussion (Misc queries) | |||
vlookup based on random result returns incorrect result | Excel Worksheet Functions | |||
Can Excel operate a function based on a true or false result? | Excel Worksheet Functions |