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.
Hi Luchoarenas12, I created a video of the solution JKPieterse shared and did some with the staff number as suggested by mathetes. You can check out the video of the solution on my Tiktok (https://vm.tiktok.com/ZNdeyEyoS/) or Youtube page (https://youtube.com/shorts/qlZo3rdhnJg).
the Youtube video seems to present the video on TikTok format, it does not show the spreadsheet on a size that would make it readable. no sure if there is a setting that would allow you to display it on a landscape mode. I might download TikTok to see if is looks better on my phone.
