HLOOKUP Error Message

[Viking0044]

I am having difficulty with the code below:

Please Login or Register  to view this content.

The above is entered in a single cell, C2 is seven characters long, and when I press enter, I get an "Error" dialog box and the above highlighted HLOOKUP is highlighted black to presumably indicate it's the problem area. If anyone has any tips for this novice user, I would greatly appreciate it. Thanks.

[shg]

Welcome to the forum.

The location is fine, the title is not. Please take a few minutes to read the forum rules, and then amend it accordingly.

[shg]

Did you build this formula up in pieces?

Please Login or Register  to view this content.

This isn't the end of your problems, but HLOOKUP searches for a match in the top row of (generally) a multi-row range, so this doesn't make sense to me:

HLOOKUP($A$1, $A:$A, $D2 + I$1, 1)