I am using Google sheets to attempt to build a tracker for my team.
I'm looking to be able to combine a 'Match' formula with an 'Offset' formula to find the value.
The intention behind this, is to be able to plug a name into a cell/sheet and have it pull said colleague's stats based of the match to offset value.
So I drop colleagues name into B4 on the first sheet/tab, which searches column B3:B20 on a second sheet/tab to match the name from B4. When it matches, it then takes the Offset value (two cells right) from the matched cell and returns that cell's value.
Is this possible? I have the two formulas working separately more or less, but I cannot seem to get them to combine properly.