Can you use a Vloopup with a Transpose function?
Is it possible to use a Vlookup function to search name in a table and return the volumes by day transposed to a separate file? I cannot seem to get the Vlookup to work with the transpose function.
I have attached two small files as examples.
If you can help me I would be very grateful.
Thank you so much for your time.
Attachment | Size |
---|---|
Table.xlsx | 9.24 KB |
Output file.xlsx | 9.47 KB |
Vlookup with Transpose
It can be done in two steps, using a third, intermediate array. I don't immediately see a way to do it with a single nested function.
I'll check back on this tomorrow. If you or someone else has not posted a solution, I'll finish and send mine.
Good luck, and thanks for the puzzle!