Hi,

I have two worksheets, sheet 1 and sheet 2. In sheet 2 I have numerous
rows of text and in column two numbers associated with the text in
column 1 e.g.

A B
1 Target 20,000
2 Actual 13,000

I have given these a 'range name' e.g. Sales

In Sheet 1, I need to use an HLookup function which pulls in Cell B1
from sheet 2 into sheet 1's C3 using the named range e.g.

=HLOOKUP(B1,Sales,$C$1,0)

This formula keeps creating an N/A error and I don;t know why. Does
anyone have any ideas why this would be the case?

I'd appreciate any help :)