Convert text to table_array label?

  • Thread starter Thread starter Hawk Lava
  • Start date Start date
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?
 
I though I would rephrase my question since I didn't get a response...

I have several pivot tables that I have named as wk1,..., wk35.

I can use this array labels in my vlookup function. Works great.

I now want a table of vlookup functions where I can index through my
array labels.

Here is an example..

VLOOKUP($C25,wk22,2,FALSE)
the next would be
VLOOKUP($C25,wk23,2,FALSE) and so on through my list of labels.

Because I have a whole table of these functions, I'd like to index
through the array name list.

I have tried generating the wk22 with concatenate("wk", A21-1). ===
wk22, but the vlookup function doesn't like it. I assume because it is
text.

Any ideas on how to index array labels?

Regards,
Hawk
 
Back
Top