Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 "Student in BC" <Student in wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Trouble shooting#NA error in Array formula | Excel Discussion (Misc queries) | |||
Formula Trouble | Excel Worksheet Functions | |||
Trouble copying and pasting a formula | Excel Discussion (Misc queries) | |||
Trouble copying and pasting a formula | Excel Worksheet Functions |