Hi forum,
I asked a question previously on how I could multiply two matrices together if given a certain set of letters from A-E and multiply the correspondents together with this formula:
E.g. the absolute value to product $H$1:$L$1 (A-E) and the row that it goes down corresponding to the formula cell row is $H2:$L2. It then matches.
E.g. for AxE find columns A and E, find the row that matches the cell the formula is in, multiply the column value of A and E. Achieve result.
This works for a matrix from A-E, but it does NOT work for a matrix from S - G - F... and I'm not sure why.
I have attached my sheet for demonstration.
the FxG column is completely wrong.
FxS column is correct
EDIT: I tried changing the letters back to A,B,C and it works. I think it has something to do with letter order for some reason.
Bookmarks