Forum Discussion
Vlookup help
Hi Luchoarenas12 , the transpose function works quite well. When you use the XLOOKUP function, it will return an array and spill your data horizontally. You would then wrap the Xlookup function in the transpose function to get your final result.
First do an xlookup using the name and last name and reference your table as an array. Then return the fields you want. It will spill as a horizonal array in your sheet. Then wrap it around with the Transpose function and it will lay it out vertically.
I have attached the solution in a workbook using the names and staff number. Please let me know if this works and if it does, please mark as solved. Thank you.
Not sure what you mean by "I went on a search for employee numbers" -- if you're in an organization of any size, they certainly exist. It's possible you're not in a position to be granted access to them (for privacy reasons), but if that's the case, for your purposes only you could simply assign unique numbers to each person under your purview.