VLOOKUP -- Table Array Problem
 

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.

VLOOKUP -- Table Array Problem
 

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


On Jun 19, 5:16 pm, DD14128 wrote:
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.