Using VLOOKUP and HLOOKUPS with named ranges

N

nadia.younus

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Post my named ranges in column A 10
Confusion Using Named Ranges 11
Eliminate blanks while copy row and transpose 11
Copy columns and paste with blank column between 5
Using named ranges in macro 6
Macro for Creating Word Document!! 5
Multiple Dynamic Named Ranges across Columns 3
Automating creation of named ranges??? 4

Top