Hi,
I need to return a value (in Sheet2) - the last 6 letters of a row of cells (e.g. GroupA) if the first 2 letters (e.g. S1) is equal to the column name of Sheet2. And the value must only be returned under the correct column - if first 2 letters (S1) matches the column name.
Please see the screenshots for the values and example output I'm looking for.
Also attached an excel file for reference.
Been spending all night but can't figure this out. Help is much appreciated. Thanks!
Bookmarks