XLookup results in vertical way??
10 views
Skip to first unread message
Eric S.
Dec 21, 2024, 10:03:37 AM12/21/24
to Google Sheets Community
Hello, I'm working on a MacBook, Sequoia 15.1.1. In my Excel 2019 version, XLookup is not available, so I temporarily switched to Google Sheets, where this feature can be used for free.
See the attached practice file (.gsheet).
Using the drop-down list (E2), the XLookup function in F2-H2 can be used to extract data from the table. That runs well. Now I want to put this data (Name, Amount, Direction) directly in column form instead of row form. Any ideas on how to do that?
Thanks for your thoughts.
See the attached practice file (.gsheet).
Using the drop-down list (E2), the XLookup function in F2-H2 can be used to extract data from the table. That runs well. Now I want to put this data (Name, Amount, Direction) directly in column form instead of row form. Any ideas on how to do that?
Thanks for your thoughts.
Eric
Reply all
Reply to author
Forward
0 new messages