Hi. I am using Excel, but I think this may be the same in Sheets.
For a couple categories (Reimbursement and Gifts), I would like to set up details sheets (one each) so I can look at and manipulate the data separate from the transactions tab, and add extra fields. (Although the extra fields may have to be on the transactions tab.)
I know I can filter within the transactions tab, but I can’t total or use conditional formatting and such. I would just rather work with it in a separate tab and pull in the data from the transactions sheet (dynamically).
I started to set up a new tab and set up a Vlookup, but that only works when the lookup field is in the leftmost column. I tried Xlookup a bit but that seems to return only one value. Any suggestions for how to go about this?