agwalsh
asked on
using vlookup (or something like it) to generate a list of values
I know Vlookups only give me the first occurrence of a matching value but suppose I wanted to generate a list/range of values..e.g. in the attached file, how would I generate (for example) a list of all the cars with a basic premium of C (or A or B)? vlookup-EE-example.xlsx
Use of a Filter (where you can select criteria) or a Pivot Table...
Just select one cell on your table and click on the Data tab, on the Filter button. This will create an auto filter to your data. Then just click on the arrow on cell C10, deselect "Select All" and just select "C". Take a look at the attached file.
jppinto
vlookup-EE-example.xlsx
jppinto
vlookup-EE-example.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've given the full marks to this one expert because it was exactly what I was looking for - the person I am helping this with is already familiar with pivot tables and filters. This formula was what they were looking for. Thanks to everyone else for their help as well.
the quickest and easiest way would be with a pivot table. Click inside the data table, then click Insert > Pivot Table and select where to put the pivot table. In the panel that appears on the right, drag the Category into the row labels and the holder name (or any other column label) underneath.
see attached.
cheers, teylyn
vlookup-EE-example--1-.xlsx