Row reference formula not working with a VLookup

  • Thread starter Thread starter Roibn L Taylor
  • Start date Start date
R

Roibn L Taylor

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.
 
=MATCH(B22,"firstcolumnofsearcharea,0)

Than you know at which place it occurs. Add a certain number of rows if
needed.
 
With "LabRow" being a named range, try this:

=--MID(CELL("address",labrow),FIND("$",CELL("address",labrow),2),5)+MATCH(B22,labrow,0)-1
 
I need the row number of the found name
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
 
Back
Top