Add this two column table to your sheet somewhere - I used cells M1 to
N12:

A00 GOLD
A02.1 Silver
A04.6 Bronze
A07.1 None
B00 GOLD
B04.1 Silver
B08.1 Bronze
B11.1 None
C00 GOLD
C03.1 Silver
C06.1 Bronze
C09.1 None

Then if your A, B, C values are in A1 and your numbers in B1, you can
use this formula:

=VLOOKUP(A1&TEXT(30-B1,"00.0"),M$1:N$12,2)

Copy down as required.

Hope this helps.

Pete

On Dec 16, 11:23*pm, WaltB wrote:
I want to have an out come dependent upon values in two different columns.. *
The 1st column values will be either A, B, or C. * The second Column will be
a value 0-30. *I want the result in the third column to be dependent upon
what letter is in the first column and the value in second. *The results will
be Gold, Silver, Bronze, None. *Any help in this would be appreciated, I lost
my Excel for Idiots book.

example:

if 1st is A and 2nd is 28-30=GOLD, 25.5-27.9=Silver, 23-24.4=Bronze, 23=None;
if 1st is B and 2nd is 26-30=GOLD, 22-25.9=Silver, 19-21.9=Bronze, 19=None;
if 1st is C and 2nd is 27-30=GOLD, 24-26.9=Silver, 21-23.9=Bronze, 21=None