Convert text to table_array label?

H

Hawk Lava

Hi All,

I am trying to use the vlookup function with data labels for pivot
tables. I have assigned each of the pivot tables a data label, such as
wk10.

I want to generate the data label from cells, such as
concatenate("wk", A21-1). === wk10

My problem is that vlookup will work with the data label wk10, but not
with the concatenate output. I assume it is because concatenate's
output is text and vlookup wants a table_array.

Is the a way to convert text to table_array?

Regards,
Hawk
Regards,
Hawk

I read the FAQ's at http://www.geocities.com/abcdgenealogy/ did you?
 
Top