Vlookup

[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

 

[Don Guillett]

As usual, post your coding efforts for comments but maybe this is what you
want.
x=sheets("yoursheet").cells(rows.count,"a").end(xlup).row

 

[Guest]

Thank you Don,

How do I write your reply in a VBA Vlookup ?
Thanks,
Jeff

 

[Don Guillett]

As usual, post your coding efforts for comments

 

[Guest]

Worksheet # 1 Worksheet # 2
A H
B G
C I
D
E
Referenced Row
H
G
hopefuly, this would be clearer. I want to do a vlookup b/w worksheet 1/2
but with a range below the row refered as Referenced Row only.