Using VLOOKUP and HLOOKUPS with named ranges
 

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 :)

Using VLOOKUP and HLOOKUPS with named ranges
 

Hi

What do you have in B1 and C1?

--
Regards
Roger Govier

wrote in message
...
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 :)

Using VLOOKUP and HLOOKUPS with named ranges
 

Hi
you might need Sheet2!Sales

in your formula
regards
Paul

On May 1, 10:43*am, wrote:
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 :)