Try this instead ... it's a little shorter:

=CELL("row",labrow)+MATCH(B22,labrow,0)-1
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"RagDyer" wrote in message
...
With "LabRow" being a named range, try this:

=--MID(CELL("address",labrow),FIND("$",CELL("address" ,labrow),2),5)+MATCH(B22,labrow,0)-1

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Roibn L Taylor" wrote in message
...
I am trying to find the row number of data that is found using the
VLookup.

=ROW(VLOOKUP(B22,LabRow,1,FALSE))

B22 = a name (name to be looked up in a list to find the row number)
LabRow = a list of names to find the name

I need the row number of the found name

The above formula will not continue states - Formula Error, can any one
tell
me what is wrong or a formula that will find a row number of a certain
criteria in a list.