View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chuck M Chuck M is offline
external usenet poster
 
Posts: 54
Default Row # of successful vlookup

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.