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.
I would suggest (writing as a former director of a major corporation's hr database), instead of just first and last names, since this IS an employee list, that you use a unique employee number--surely there is one--or if you don't have your own internal system, each person's SSN. That's a far more long-term-reliable method of identification than names. Inevitably, somebody else will come along with the same name as an already established employee.
Once you have done that, you can modify the formula from JKPieterse or develop your own more simple formula to extract the data.
Thank you! that's a great idea. I have no applied JKPieterse formula yet. but yeah the employee number will make the reference easier lookup value easier to match.