Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Proper function for a chart
I am trying to determine the proper function to use in a worksheet. I need
the formula to take info from cell 1, and cell 2, plot these on an x and y axis chart and return the z response to cell 3. What function would do this and what might the formula look like? Cell 1 is the state the item is shipping to, cell 2 is quantity ordered, cell 3 would determine the shipping charge based on information in those cells. I have set up a chart and have tried vlookup but doesn't seem to do what I want it to. A second question would be also in vlookup. I have a list but it won't always recognize the number and return the correct response. It will recognize part of a series but not all of it and cannot figure out why. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Proper function for a chart
The function you want is Index/Match
=INDEX(ChartValues,MATCH(State,ColumnOfStates,0), MATCH(Qty,RowOfQuantities,0) -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Curt" wrote: I am trying to determine the proper function to use in a worksheet. I need the formula to take info from cell 1, and cell 2, plot these on an x and y axis chart and return the z response to cell 3. What function would do this and what might the formula look like? Cell 1 is the state the item is shipping to, cell 2 is quantity ordered, cell 3 would determine the shipping charge based on information in those cells. I have set up a chart and have tried vlookup but doesn't seem to do what I want it to. A second question would be also in vlookup. I have a list but it won't always recognize the number and return the correct response. It will recognize part of a series but not all of it and cannot figure out why. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TO GET PROPER CONNECTORS FOR CHART IN EXCEL | Charts and Charting in Excel | |||
PROPER function | Excel Worksheet Functions | |||
How do I use the PROPER function? | Excel Worksheet Functions | |||
PROPER function | Excel Worksheet Functions | |||
How do I use the PROPER function? | Excel Discussion (Misc queries) |