Hello,
Here is my formula
"=INDEX(Report!R3C4:Report!R933C4,MATCH(Compare!RC[-1],Report!R3C2:R933C2,0))"
This works fine. However i want to make it dynamic. Number of rows in the sheet report will vary. So i want to make it dynamic array. I can use the following method to find the number of rows
Lastrow = Cells.Find("*", [A1], , , xlByRows, xlPrevious).Row
How Can i make the index formula dynamic with this variable?
Bookmarks