Formula to lookup the row number

P

Petitboeuf

Hiya Experts!

I am trying to get a simple formula in Excel to return the row numbe
based on a lookup.

I'll try to clarify if this doesn't make sense.

I have in cell A1 of Book1 a text. Based on that text I want in cell B
of Book1 enter the ROW where the same text is in Book2.

I guess it's a tweak of vlookup but I fail to return the row number...

Many thanks
 
D

Dav

Have you tried the match function
If for example your range of data to compare against was c1:c35

MATCH(A1,Sheet2!C1:C35,0)

This gives you the row of the first match. If your data started in row5
for example amend the formula MATCH(A1,Sheet2!C5:C39,0)+4.

The final 0 in the formula just ensures an exact match


A vlookup would work but you would need to add a colum with the numbers
in.
 
Top