How to return multiple rows with a Vlookup
To make a Vlookup function return multiple rows you must use a helper column. The helper column should count how items are the same. A second helper column should use the concatenate feature to join the helper column with a cell reference. To set up the Vlookup it should also use concatenate as a reference. this way multiple records will be returned. How to return multiple rows with a Vlookup. LibreOffice Calc tutorial.
#calc
#vlookup
#libreoffice
If you want to support me, check this out: / itseasy
Classroom based courses can be arranged at https://www.itseasy.co.uk/
Courses are available through Microsoft Teams, Online and Face to face in the UK
Online courses at https://itseasytraining.teachable.com/
Udemy Courses https://www.udemy.com/user/stephen-sa...
Training Guide Books
Excel for New Managers
https://www.amazon.co.uk/Excel-New-Ma...
Microsoft Project Overview https://www.amazon.co.uk/Microsoft-Pr...
Microsoft Visio Basic https://www.amazon.co.uk/Microsoft-Vi...
Very cheap E_books are here:
Excel For New Managers https://payhip.com/b/IE4x
Microsoft Project Overview https://payhip.com/b/wY0m
Microsoft Visio Basics https://payhip.com/b/5XeV
Microsoft Access Introduction https://payhip.com/b/ynSL
A PowerPoint Overview https://payhip.com/b/YkQv