Forum Discussion
When Array table is updated/ sorted, the adjacent column cells aren't aligned/ linked
Hi,
I have two columns of data. The first column uses UNIQUE function to bring all the unique values from a data source. Now in the second column i have classified the unique values in the Category column. Problem is when my source data is sorted, the Payee column also gets sorted. What's going wrong is, now my category column data is not aligned to the new sorted data.
How do i make my Category column data be aligned/ linked with the Payee data.
Kindly note, i want the Payee column to be sorted as it is done with the source data. I do not want to use SORT function paired with Unique function to address the issue.
5 Replies
Perhaps the attached file will help you on your way.
Hi Riny,
What you have done is created a lookup table that has all my payee details and added the category next to it. This is exactly what i've done to get over with this problem. But, now my lookup table needs to be updated every time a new payee is added (brought from my bank statements). Earlier this used to be automatically updated from my statements using the unique function. Is there a way to still use unique function in the lookup table to have the payee list automictically updated and still be able to be linked with the category that i manually assign it to?
"Earlier this used to be automatically updated from my statements using the unique function"
When you say that, I wonder how. You need to explain more. What has changed since "earlier"?
Rohan110 Well, how did you 'link' the Category to the Payee? If you just typed "Groceries" in B5, that will not automatically change/move with the Payee in A5. You could use XLOOKUP to make that link. Something like:
=XLOOKUP(A3#,payees,categories)
where 'payees' and 'categories' refer to ranges in a lookup table.
- Could you please help me with an example as this didn't work.
