Hi there,
I actually did lots of things to solve it but the solutions are always failed. I used INDEX and MATCH together to find specific data in a matrix.
so, this is my problem...
I have a mixed matrix and an original matrix ( I had a matrix then I mixed the rows and do some calculations and find something let's call it Y)
now I want to lookup specific rows from my original matrix in mixed matrix, so to know it's Y.
for example:
you see B is mixed version of A and Y={3;0;5;2} is the new column. I want to find rows of matrix A in matrix B and then return the new Y.
my matrices are big and have digits with more than 2 or 3 decimals.
Thanks for your time!
Bookmarks