Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

lookups return multiple values

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Lookups to return multiple values

Lookups to return multiple values

ResolvedVersion 365

Sinead has attended:
Half Day Only - Lookups course
Half Day Only - Lookups course
Excel Advanced with Pivot & Lookup course
Excel Advanced with Pivot & Lookup course

Lookups to return multiple values

lookups return the first value it finds - how would i bring back where there is a number of them

RE: lookups to return multiple values

Hi Sinead,

Thank you for the forum question.

Lookup and reference functions can only return 1 value but you have other options to return multiple values.

Please watch video below.

https://www.youtube.com/watch?v=Eehk6PC0oGs


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
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

Sun 25 Feb 2024: Automatically marked as resolved.

Excel tip:

Repeat action

The F4 key will usually repeat your last action. e.g. delete a row, then select another row and press F4 to delete again.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.17 secs.