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?