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
