Formula to lookup the row number
 

Hiya Experts!

I am trying to get a simple formula in Excel to return the row number
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 B1
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!


--
Petitboeuf
------------------------------------------------------------------------
Petitboeuf's Profile: http://www.excelforum.com/member.php...o&userid=10602
View this thread: http://www.excelforum.com/showthread...hreadid=503967

Formula to lookup the row number
 

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.


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=503967