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.