B
BKJ
#Hello, I am trying to structure a worksheet that uses the HLOOKUP function
to show data selected from a worksheet in a different workbook. I have
several different workbooks with several different worksheets, all structured
the same. I would like to be able to define a named cell for the table array
value in the function and then by only changing the contents of the name
cell, redirect the HLOOKUP function to the appropriate worksheet to display
the desired data. But when I substitute the sheet in the formula with the
named cell containing the name of the worksheet in the other workbook, I get
#N/A. How do I assign the name of the sheet (or the named array in the
sheet) to a variable that I can use in the formula?
to show data selected from a worksheet in a different workbook. I have
several different workbooks with several different worksheets, all structured
the same. I would like to be able to define a named cell for the table array
value in the function and then by only changing the contents of the name
cell, redirect the HLOOKUP function to the appropriate worksheet to display
the desired data. But when I substitute the sheet in the formula with the
named cell containing the name of the worksheet in the other workbook, I get
#N/A. How do I assign the name of the sheet (or the named array in the
sheet) to a variable that I can use in the formula?