what Formula or Function do I use
 

Hello All,

I need help with the following information from a table to a worksheet:

GPA Points
3.9-4.0 30
3.6-3.8 25
3.3-3.5 20
3.0-3.2 15
2.7-2.9 10
2.4-2.6 5
2.3 0

On the worksheet I add up 3 GPAs from 3 different schools, then get the
average. In the next column I want the average to show and then in the next
column I want the points to automatically appear. I am fine until the final
column - the points.

Michael

what Formula or Function do I use
 

Create a 2 column table like this:

...........C..........D
1........0..........0
2........2.4.......5
3........2.7......10
4........3.0......15
5........3.3......20
6........3.6......25
7........3.9......30

Assume A1 = average

=LOOKUP(A1,C1:C7,D1:D7)

--
Biff
Microsoft Excel MVP


"the5sheas" wrote in message
...
Hello All,

I need help with the following information from a table to a worksheet:

GPA Points
3.9-4.0 30
3.6-3.8 25
3.3-3.5 20
3.0-3.2 15
2.7-2.9 10
2.4-2.6 5
2.3 0

On the worksheet I add up 3 GPAs from 3 different schools, then get the
average. In the next column I want the average to show and then in the
next
column I want the points to automatically appear. I am fine until the
final
column - the points.

Michael

what Formula or Function do I use
 

All that comes up is #VALUE!

an Example of what I am doing is:

GPA 1 GPA 2 GPA 3 AVG PTS
3.2 3.6 2 2.933 #VALUE!

From another Excel Sheet with the GPA/Pts information.

I restacked them as you showed but the #VALUE! is all that comes up.



"T. Valko" wrote:

Create a 2 column table like this:

...........C..........D
1........0..........0
2........2.4.......5
3........2.7......10
4........3.0......15
5........3.3......20
6........3.6......25
7........3.9......30

Assume A1 = average

=LOOKUP(A1,C1:C7,D1:D7)

--
Biff
Microsoft Excel MVP


"the5sheas" wrote in message
...
Hello All,

I need help with the following information from a table to a worksheet:

GPA Points
3.9-4.0 30
3.6-3.8 25
3.3-3.5 20
3.0-3.2 15
2.7-2.9 10
2.4-2.6 5
2.3 0

On the worksheet I add up 3 GPAs from 3 different schools, then get the
average. In the next column I want the average to show and then in the
next
column I want the points to automatically appear. I am fine until the
final
column - the points.

Michael

what Formula or Function do I use
 

THANK YOU T. Valko!!!!!! I figured it out. I had the wrong starting column
and cell information. Thanks!!!!

"the5sheas" wrote:

Hello All,

I need help with the following information from a table to a worksheet:

GPA Points
3.9-4.0 30
3.6-3.8 25
3.3-3.5 20
3.0-3.2 15
2.7-2.9 10
2.4-2.6 5
2.3 0

On the worksheet I add up 3 GPAs from 3 different schools, then get the
average. In the next column I want the average to show and then in the next
column I want the points to automatically appear. I am fine until the final
column - the points.

Michael

what Formula or Function do I use
 

Ok, good deal!

Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"the5sheas" wrote in message
...
THANK YOU T. Valko!!!!!! I figured it out. I had the wrong starting column
and cell information. Thanks!!!!

"the5sheas" wrote:

Hello All,

I need help with the following information from a table to a worksheet:

GPA Points
3.9-4.0 30
3.6-3.8 25
3.3-3.5 20
3.0-3.2 15
2.7-2.9 10
2.4-2.6 5
2.3 0

On the worksheet I add up 3 GPAs from 3 different schools, then get the
average. In the next column I want the average to show and then in the
next
column I want the points to automatically appear. I am fine until the
final
column - the points.

Michael