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

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

THANK YOU!!! I definitely need to take an excel class. My spread sheet is
up and running and works great, thanks much to the both of you!

"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

You're welcome, Walt.

Pete

On Dec 17, 6:38*pm, WaltB wrote:
THANK YOU!!! *I definitely need to take an excel class. *My spread sheet is
up and running and works great, *thanks much to the both of you!



"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- Hide quoted text -

- Show quoted text -