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