=MATCH(B22,"firstcolumnofsearcharea,0)

Than you know at which place it occurs. Add a certain number of rows if
needed.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Roibn L Taylor" wrote:

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.