Two way lookup where row isn't know?

[MrPez]

I need a formula to find a specific word in column A then find another word on that row, and then give me the column number that the second word is in.

So the first part would be =MATCH("Word1",A:A,0)

The second part would be =MATCH("Word2",Row:Row,0)
where Row is the result of the previous formula.

However, I'm struggling to combine the two formulae?

 

[Snakehips]

TBH, i'm not sure of Snakehips' suggestion or what it's trying to solve.

the match() in post#4 is looking for the exact match anyway

Forgive me if I'm being unnecessary but I was thinking of the scenario below.

Excel 2010
	A	B	C	D	E
1
2
3			Word2
4			Word3
5	Word3		Word4
6	Word7	Word2	Word5
7	Word1		Word7	Word2	Word2
8	Word2
9
10
11
12
13	1	<
14	4	<
15
.78

Cell Formulas
Range	Formula
A13	=MATCH("Word2",INDEX(A1:E10,MATCH("Word1",A1:A10,0),0))
A14	=MATCH("Word2",INDEX(A1:E10,MATCH("Word1",A1:A10,0),),0)

 

[AlanY]

Forgive me if I'm being unnecessary but I was thinking of the scenario below.

Excel 2010
	A	B	C	D	E
1
2
3			Word2
4			Word3
5	Word3		Word4
6	Word7	Word2	Word5
7	Word1		Word7	Word2	Word2
8	Word2
9
10
11
12
13	1	<
14	4	<
15
.78

Cell Formulas
Range	Formula
A13	=MATCH("Word2",INDEX(A1:E10,MATCH("Word1",A1:A10,0),0))
A14	=MATCH("Word2",INDEX(A1:E10,MATCH("Word1",A1:A10,0),),0)

no no no, you were right to point it out.
please accept my apology
i just couldn't see the typo in my original formula until mod Fluff pointed it out.

it's Friday afternoon after all.