Hi all,
I am wondering if there is a way on alteryx to find a specific amount contained in a given tab when the file contains multiple sheets. I explain:
I have an excel file ('references' attached) with the references below (with T the tab, r the row and c the column where the amount can be found in the second file ("amounts' attached)).
| Y1 | Y2 | Y3 |
v | (T01, r10, c10) | (T02, r10, c20) | (T01, r10, c30) + (T02, r30, c30) |
x | (T01, r20, c10) | (T03, r20, c20) | (T01, r20, c30) + (T02, r30, c30) |
My second excel file ('amounts') contains multiple sheets with different format as per the file attached,
What I am trying to do is to complete the first table and replace the references with the data that is contained in the second file, the pb is that this second file contain multiple sheets, so I am struggling to find a way to pick up the right amounts.
Thank you for your help!
