Hi
I am trying to match a value within another sheet i.e. a position in another sheet based basically on column and row, but this will vary depending on what is selected.
https://docs.google.com/spreadsheets...#gid=462775805
This is the sheet. You can see in the total column, i have used index and match and used match to return the row and column, depending on what is selected.
What i am confused about is why the first one returns correct but the other values are just blank?