How can I get the row number from a vlookup?
Solution 1:
I believe that you want "match."
=MATCH(E2,Sheet2!A:A,0)
If you want to return the value from that cell, you can use the following:
=INDEX(B:B,MATCH(E2,Sheet2!A:A,0))
But, to be clear, the above is only for illustration, as you should use the following instead in that particular circumstance:
=VLOOKUP(E2,Sheet2!A:B,2,FALSE)