Vlookup

J

Jeff

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
 
D

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
 
J

Jeff

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.
 
Top