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.

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.