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.

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

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.12 secs.