Trouble with formula on Student 2006 learning essentials template

[Guest]

I'm having trouble with a formula on Student 2006 software and it comes with
the learning essentials for Microsoft office. It has numerous templates. The
specific template is the Grade Tracker. When I opened up the template to use
and modify there was a formula that was found to be inconsistant. It is quite
complex and have no idea how to fix it. The formula looks like this:
=IF(C15<>"",HLOOKUP(C15,'GPA Table'!$B$5:$N$7,2),"")

If anybody could be of any assistance that would be helpful as I would like
to use this template for my studies.

 

[Biff]

Hi!

Just a guess....

You mentioned:

When I opened up the template to use and modify

Did you modify the table?

As written, the formula needs to have the table sorted in ascending order or
incorrect results could be returned. Provided that the table needs to be
sorted in the first place! (but it looks like it does based on the name: GPA
Table)

Just as a test try this and see if it corrects the problem:

=IF(C15<>"",HLOOKUP(C15,'GPA Table'!$B$5:$N$7,2,0),"")

We may need more detailed info.

Biff