Jun 04 2021 07:55 AM
Hi so as you can see in the file, I would like to extract the values from the sheet "Master -5,5" to the sheet "Jogadores", but I want to be the values corresponding to the exact name on the row and the value of the column, I have tried Index and match match but when it is time to change for a different name it just extracts the wrong one.
Jun 04 2021 08:20 AM
Solution
A couple of things I noticed --
The "match" portion of your formula was trying to lookup the name in the original master table within the master table. Instead, in "Jogadores", match the value there against the master table. For example,
MATCH(Jogadores!H$2,'Master (-5,5)'!$B$2:$BR$2,0)
Same for the "abnormal" data in column A:
MATCH(Jogadores!$A4,'Master (-5,5)'!$A$3:$A$13,0)
All that aside, make sure your index/match is in the right order.
INDEX(Reference,Row Number,[Column Number],[Area Number])
I think you had column, then row in your original formula.
Lastly, you probably noticed that I used absolute cell references. This will help keep your formulas pointing to the right set of cells.
Cheers
Karl
Jun 04 2021 08:25 AM
Jun 04 2021 08:20 AM
Solution
A couple of things I noticed --
The "match" portion of your formula was trying to lookup the name in the original master table within the master table. Instead, in "Jogadores", match the value there against the master table. For example,
MATCH(Jogadores!H$2,'Master (-5,5)'!$B$2:$BR$2,0)
Same for the "abnormal" data in column A:
MATCH(Jogadores!$A4,'Master (-5,5)'!$A$3:$A$13,0)
All that aside, make sure your index/match is in the right order.
INDEX(Reference,Row Number,[Column Number],[Area Number])
I think you had column, then row in your original formula.
Lastly, you probably noticed that I used absolute cell references. This will help keep your formulas pointing to the right set of cells.
Cheers
Karl