How recover location with vlookup...
 

I need to recover the cell location using vlookup between two sheets. ie.
ActiveCell from actual worksheet, data_range i other worksheet(other file).

Application.VLookup(ActiveCell.Value,data_range, 1, True)

I need the cell location (in data_range) if the vlookup is OK.

thanks, Iván

How recover location with vlookup...
 

Hi
use Application.Match to get the row index

--
Regards
Frank Kabel
Frankfurt, Germany

"Iván" schrieb im Newsbeitrag
...
I need to recover the cell location using vlookup between two sheets.
ie.
ActiveCell from actual worksheet, data_range i other worksheet(other
file).

Application.VLookup(ActiveCell.Value,data_range, 1, True)

I need the cell location (in data_range) if the vlookup is OK.

thanks, Iván