# Thread: Two way lookup where row isn't know? Thanks:  1 Post #5311956 (1) Likes: 0

1. ## Re: Two way lookup where row isn't know?

Originally Posted by AlanY
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
ABCDE
1
2
3Word2
4Word3
5Word3Word4
6Word7Word2Word5
7Word1Word7Word2Word2
8Word2
9
10
11
12
131<<Alan
144<<Snake
15

.78

Worksheet Formulas
CellFormula
A13=MATCH("Word2",INDEX(A1:E10,MATCH("Word1",A1:A10,0),0))
A14=MATCH("Word2",INDEX(A1:E10,MATCH("Word1",A1:A10,0),),0)

2. ## Re: Two way lookup where row isn't know?

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

Excel 2010
ABCDE
1
2
3Word2
4Word3
5Word3Word4
6Word7Word2Word5
7Word1Word7Word2Word2
8Word2
9
10
11
12
131<
144<
15

.78

Worksheet Formulas
CellFormula
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.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•