Hi everyone, I hope someone can help with this.

A simple sample of what I like to do is this.

A B C D E F G H I

1 60% 70% 80% 90% 74% 1.6% ?

2 1% $10 $20 $30 $50


3 5% $40 $50 $60 $70

Range B1:E1 is the sales person's market share at the end
of the month. Range A2:A3, say it his/ her change in
market share from previous month. I like to be able to
pay this person base on his/ her performance in cells G1
and H1. This person ended the month with 74% market share
and an increase of 1.6% from previous months.
What formula in I1 would "look" at G1 and I1 and find the
closest match in the matrix? In this case it would be $20.

I know how to use Vlookup, Hlookup, but this is a two
dimensional "addressing"

I hope someone has the answer