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

trying return mulitple values

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Trying to return mulitple values using vlookups

Trying to return mulitple values using vlookups

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

Trying to return mulitple values using vlookups

sometimes we are using xlookup and we have more than one value that meets the criteria. when i use xlookup it only brings back the first one it finds - how do i get the rest

RE: trying to return mulitple values using vlookups

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

Excel tip:

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.

=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

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