Trying to return mulitple values using vlookups | Excel forum

Resolved · Low Priority · Version 365

Thu 15 Feb 2024, 12:52 Delegate Sinead said...

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

Sun 18 Feb 2024, 11:00 Trainer Jens said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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