Hello,
I want a formula to take the value of a cell 5 rows above in the same sheet, find the matching value in a different sheet, and return the value of the cell directly below it. I need this to repeat for several rows. Sort of like a counter in a formula.
For example,
I want Cell A5 to take the value of A1, find it in column B of sheet 1, and return the value of the cell below it.
Then I want cell A10 to take the value of A5, find it in the column B of sheet 1, and return the value of the cell below it. And so On and so Forth for several hundred rows.
EDIT: Index Match seems to work. But I'm open to your suggestions anyway...
Thanks!
Bookmarks