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 applied the =(TRANSPOSE(XLOOKUP() ) on my original spreadsheet and it work wonders, but because my list of skills is very large some employees have a long list of 0s, I can use a filter above my operator role to filter the 0s, but I was wondering if the "if no found" feature of Xlookup would allow me to filter blanks cells, because empty cells have no data on my table.
Yes, you could use the "if not found" option in XLOOKUP but most times when it returns 0, it may mean that the record was found but there was no corresponding value in the field that is to be returned.
As a work around, you could try wrapping your formula in an IF function. For example, IF(B2 = 0,"No record",TRANSPOSE(XLOOKUP()))