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.