View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Student in BC
 
Posts: n/a
Default Trouble with formula on Student 2006 learning essentials template

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.