Russell,

As there will be multiple A for rates, I would not hold it all in one table
but have two tables and use the results of one lookup to do a lookup into
the second.

However, if you want to continue as you were, assuming the number is in A,
the letter is in B, and the rate is in C1, use

=INDEX(C1:C10,MATCH(20&"A",A1:A10&B1:B10,0))

which is an array formula, so commit it with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Russell Hampton" wrote in
message ...
Thanks Bob. I think that I have it working. Here is a followup question.

I have the column returning the A or B. Now that information along with a
third column needs to be used to give me a rate. So A and 21 is 9.5 but A
and
22 is 10.5. The VLOOKUP doesn't seem to like the three dimensions that I
think I will need in my table. Is there another type of formula that will
work. Sometimes I think that it would be easier for MS to give us IF, THEN
and ELSE statements. Thanks again, Russell

"Bob Phillips" wrote:

=VLOOKUP(A1,{720,"A";600,"B"},2,FALSE)

just extend that range or put it into a worksheet range and use that.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Russell Hampton" wrote in
message ...
I am trying to create a column that will convert a number score into a
letter
score based on a range. For instance, if the cell has 720 in it then I
want
an A to print in another cell. If the number is 600 then a C should
print.
I
can get it to print using an IF statement so long as there is only one
option. Any ideas for multiple options? I tried VLOOKUP but that
doesn't
work.