Function to match entries between two tables
To help me manage my guild members’ scores for a recurring event in my game, I’m looking for a way to ensure that the data from my “DV Score” table is transferred to the “DV Final” table.
The first screenshot shows the “DV Score” table and the second screenshot shows the “DV Final” table.
Given that the position of members in the ‘DV Final’ table may change, my aim is to ensure that the data from the ‘DV Score’ table is transferred to the other table based on the linked member’s name.
I have already tested using =INDEX(E1:E35, MATCH(‘Yurilowel’, “DV Score”!A3:A22, 0)), trying to get it to return the value 15480 from cell C3, but it simply returns an empty cell
(EQUIV is the french function for MATCH)
[link] [comments]
Want to read more?
Check out the full article on the original site