V-lookups, lists

Hi Jack

Thanks for getting in touch. A VLOOKUP by design only returns one result. To create more responses you'll have to create it as an array formula, which can be painful to maintain.

If this is the kind of thing you need, a PivotTable might be a better option. If you add a Slicer to this PivotTable you will get a interactive list you can select to show those matching items.

To add a Slicer to your PivotTable, on the PivotTable menu click Insert Slicer. Then select the items you want to filter by.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector