combining row() with a vlookup

[robertdseals]

Hello,
I would like to combine row() with a vlookup. So, if my data set looked like:
a b c
1 Apple
2 Banana

and down on row 17 I had
17 Apple

I would want to put in a formula that would be something similar to:
=row(vlookup(A17,A1:A2,1,0)) that would vlookup "apple" in cells A1 - A2 and return the row number that it is on. Any ideas?

 

[delaneyjm]

Take a look at the MATCH function.

MATCH returns the row number if a match is found.

Given your vlookup formula, you should be able to do =MATCH(A17,A1:A2,0)

 

[robertdseals]

That would only work if they lined up right. What if my data set started on A6? Match would still give me an answer of 1 when what I want to know is what row is this on.

 

[robertdseals]

Wait! You are right. If I do Match(A17,A:A,0) that would work. Thanks!