Excel INDEX and MATCH formulas - find column letters

Question

is it possible to replace part in bold ('FPS raw'!M:M & 'FPS raw'!K:K) so that it finds the right column letters each time, based on E2 formula: B2 ->> =INDEX('FPS raw'!M:M,MATCH(A2,'FPS raw'!K:K,0)+1)

B2 formula:

=INDEX('FPS raw'!M:M,MATCH(A2,'FPS raw'!K:K,0)+1)

E2 formula:

=SUBSTITUTE(ADDRESS(1,MATCH(A1,'FPS raw'!1:1,0),4),"1","")

Formulas used:

question from:https://stackoverflow.com/questions/66064476/excel-index-and-match-formulas-find-column-letters

Answer 1

Use:

=INDEX(INDEX('FPS raw'!$A:$ZZ,0,MATCH($B$1,'FPS raw'!$1:$1,0)),MATCH($A2,INDEX('FPS raw'!$A:$ZZ,0,MATCH($A$1,'FPS raw'!$1:$1,0)),0))