Forum Discussion
Need help extractign values from one table to another
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
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
