VBA Vlookup

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

Guest

Hello,

I need a VBA formula that would execute a Vlookup between 2 workbooks.
However, the range for the Vlookup starts from a row that has a text, but
never has the same row number. In other word: it is possible to have a
Vlookup with a range starting from a referenced row that moves all the time ?
Jeff
 
Give the referenced row a name through Insert>Name. Now, in the code refer
to the row through it's name and Excel will dynamically locate it.
 
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

Vlookup 4
vlookup range 4
Excel Vlookup Help 0
vlookup copy down 1
Inserting function into worksheet via macro 4
VLOOKUP returning #N/A result 2
Vlookup alternative 2
=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ", VLOOKUP(A3,con 4

Back
Top