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.
Thank you! I went on the search for employees numbers to use as reference, I have no made changes to my original file, I tried the transpose advise but i think I messed the cell numbers.
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.
Thank you! this is what I had in mind. I really appreciate all the help