You would use:

COLUMN(F1)=6
rather than =1 (ie the column number of first column being compared)

for a more transparent version you could use

=MATCH(-F1;INDEX($F:$G;0;1+(COLUMNS($F1:F1)=1));0)
or

=MATCH(-F1;INDEX($F:$G;0;1+(COLUMN(F1)=COLUMN($F1));0)