Hi,
Can Index Match be used for different data length and across multiple workbooks?
e.g.
Workbooks A , data Range("G13:G50")
Workbooks B , data Range("G13:I600")
the lookup value is G13 to G50 in Workbooks A, while the returned value is from I13 to I600 in Workbooks B
can anyone help me?
Bookmarks