Obtain Row reference via VLOOKUP()

D

Dennis

Using XL 2000 & 2003

Now sure of the most efficient way to get a Row reference on Sheet1 from "Sheet2" using VLOOKUP()

Vlookup() will find the cell in a table-range on sheet2. I do not need the contents of the cell in
that lookup-table, just its row number as text.

I do know how to use Vlookup()

In short, the logic (not the syntax) of the formula I need help with is:

=CellRowAsText(Vlookup(table on sheet2))

TIA Dennis
 
K

Ken Wright

Try using MATCH

=MATCH(C1,A1:A100,0)

If your table doesn't start in row 1 then either adjust your MATCH array to do
so, or make an adjustment based on the starting row of the table.
 
B

Bob Phillips

Assuming the table is in K5:K20

=ROW(K5)-1+MATCH(lookup_val,K5:K20,0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
D

Dennis

Thanks to all !!

Not knowing where or what combo of functions with which to start is frustrating.

We all have learned much - because of the XL helpers.

Dennis
 
Top