Row reference formula not working with a VLookup
 

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.

Row reference formula not working with a VLookup
 

=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.

Row reference formula not working with a VLookup
 

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.

Row reference formula not working with a VLookup
 

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.

What is wrong:
VLOOKUP finds the value in a cell. Can't get the row number from that.
MATCH finds the row number of a cell. But it may be tricky....

Note that MATCH finds the row number within the data area you specify,
not necessarily the Excel row number. So, if your data is in A3:D10
and the MATCH returns "3", it means the 3rd line of data, so the
reference it found is in cell A5. This is why Wigi said "Add a certain
number of rows if needed". Depending on what you want Excel to do, you
may need to add an amount to the MATCH to make it meaningful. In my
little scenario, you'd add 2 since you are looking at something that
is actually in A5 and you'll need Excel to see "5". So Wigi's formula
becomes: MATCH(B22,A3:A10,0)+2

Row reference formula not working with a VLookup
 

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.