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 Catego...
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.