Row # of successful vlookup
Spiky & JP - Thanks to you both for your quick response. Will use MATCH
instead.
--
TIA
Chuck M.
"Spiky" wrote:
On Aug 19, 3:10 pm, Chuck M wrote:
Hi - Is there any way to know what the row # of a successful vlookup is?
Ex. From the following 2 column, 3 row lookup range:
col 1 col 2
row 1 John A
row 2 Tom B
row 3 Jim C
Vlookup(lookup range,"Tom",2,False) returns 'B'. Is there any way to know
that B is on row 2 of the lookup range?
--
TIA
Chuck M.
No. So use Match instead.
MATCH("Tom",lookup_range,0)
|