VLOOKUP -- Table Array Problem

D

DD14128

I am trying to reference a range of data on another sheet in the "table
array" portion of the VLOOKUP function by pointing to a cell in my current
sheet that is then linked to that range but I am getting an error message
reading: "#N/A" and the message tells me that the Table Array is the source
of that error.

Here is how I constructed the VLOOKUP:

=VLOOKUP(A29,B27,2,FALSE)

where B27 references: Sheet2!$A$1:$H$11. This is where the "#N/A" error
message pops ups. How can I set up this formula so the B27 cell can
reference another range in another sheet? Thanks.
 
V

vezerid

If the contents of B27 are the sheet name and cell address,

=VLOOKUP(A29,INDIRECT(B27),2,FALSE)

Otherwise you can use the range reference directly:

=VLOOKUP(A29,Sheet2!$A$1:$H$11,2,FALSE)

HTH
Kostis Vezerides
 

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

VLOOKUP duplicate values in table the table array? Help me solve 1
Vlookup and return sheet name also 2
How do I insert a dynamic reference of a range inside VLOOKUP? 4
trouble with (complicated) vlookup searching another workbook 2
Dates In Excel 5
vlookup formatting problem 1
VLookup Won't Copy down (#REF! error) 1
Vlookup-table array runs? 2

Top