trying return mulitple values

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

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

Trying to return mulitple values using vlookups | Excel forum

resolvedResolved · Low Priority · Version 365

Sinead has attended:
Half Day Only - Lookups course
Half Day Only - Lookups 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:

Apply currency format quickly in Excel

To quickly apply the currency format to cell in your spreadsheet, select (highlight) the cells you wish to apply currency format to, then use Ctrl + Shift + $

This will apply a pounds symbol even though the $ key is pressed.

View all Excel hints and tips


Server loaded in 0.07 secs.