Return lists of values by looking up dynamic value from pivot table (HLOOKUP?)

**MrBee** · 07-05-2022, 07:28 PM

Hi all,

not sure how to go about this but haven't been successful with anything tried so far - I'm sure someone can do this in a matter of seconds!
Basically, I want to use a pivot table to return a number of spelling word lists based on problem areas that I dictate. The word lists will all have the problem areas assigned manually.
The idea would be to use the pivot table to filter the list numbers in A7:A166, which would then search 'Word Lists'!A1:FD1 and return the list of words below the corresponding list numbers into the cells from D1 across.

I've uploaded the spreadsheet, thanks in advance.

**XLent** · 07-06-2022, 07:15 AM

if using O365, you might try something like:

Formula:

Please Login or Register  to view this content.

the above will return the respective lists, as dictated by the Pivot list.

**MrBee** · 07-06-2022, 07:51 PM

Well, I was never going to arrive at that solution by myself - thanks, exactly what I'm looking for.

Return lists of values by looking up dynamic value from pivot table (HLOOKUP?)

LinkBack

Thread Tools

Rate This Thread

Display

Return lists of values by looking up dynamic value from pivot table (HLOOKUP?)

Re: Return lists of values by looking up dynamic value from pivot table (HLOOKUP?)

Re: Return lists of values by looking up dynamic value from pivot table (HLOOKUP?)

Thread Information

Users Browsing this Thread

Similar Threads

Pivot Table filter on dynamic range of cell values

Changing Pivot Table values based on Multiple, Dependent Data Validation Lists

[SOLVED] Hlookup to return a sum of values

Looking to use a Pivot Table or Macro to return specific values from a table

how to return top ten values and build a new table without using pivot table

Pivot Table (vlookup 2 column text values, return 1 value)

[SOLVED] How do I return dynamic lists?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions