How recover location with vlookup...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extremely slow file 3
Best way to run Find or Vlookup down specific column in range 2
How I can to Use False in Vlookup? 1
Using VLookup in VBA code with variable range 15
using vlookup in vba 10
retrieve an AVERAGE of a range using VLOOKUP to locate start/end d 1
Populating a range of empty cells with usernames 4
Runtime error 1004 when trying to insert formula in cells 11

Back
Top