Lookup Help

Hi!

Is there a formula/function where you can do a lookup similar to VLOOKUP but instead of getting the top value in the lookup, you are able to lookup ALL values instead? It's like multiple value lookup.

Hope I can get help here. Thanks!

All Excel lookup functions, i.e. Vlookup, Hlookup, Lookup and Match only return one value, not a range.

Please explain the bigger picture. Don't get hooked on using a specific formula. There may be a different approach.

What do you want to achieve?

Originally Posted by npamcpp

All Excel lookup functions, i.e. Vlookup, Hlookup, Lookup and Match only return one value, not a range.

Please explain the bigger picture. Don't get hooked on using a specific formula. There may be a different approach.

What do you want to achieve?

What I want actually is to place all values under 1 field into 1 column. Right now, the database that I'm using has all the values spread out vertically. What I'm trying to do is to transpose them vertically, but instead of transposing everything horizontally, I want to just have one set of fields transposed, and just have all the values under it follow.

Please see the attached file of the database I'm using and the product I want to produce. A Macro code was an option but did not work because of the uneven number of rows per set.

Sorry, can that not be demonstrated with a smaller data sample? I'm on a data plan and over the limit.