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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to getting text labels to show up in scatter chart. 0
Excel does not accept text format! 0
How do I reference a "range" for a specific table_array in VLOOKUP 3
Pivot Table Counting Text Data 0
Pivot Table Counting Text Issue 0
vlookup not working with defined name 3
VLOOKUP -- DYNAMIC TABLE_ARRAY VALUE 4
Converting labels to text 1

Top