Hello friends, please help with this problem I'm having.
I have two spreadsheets: One.xlsx and Two.xlsx
I am creating a formula in One to retrieve data from Two. As shown below, the formula in One is pointing to Two, BUT, in this instance the formula doesn't KNOW to go to row 11, it only knows the range B to CC. The row 11
actually comes from a cell in [One.xlsx]Sheet1'!BF17 which contains the formula: =MATCH(B17,'[Two.xlsx]Sheet1'!$B:$B,0)
This formula is in One.xlsx
=INDEX('[Two.xlsx]Sheet1'!$B11:$CC11,E$13-1)
So, how do I replace these two 11's with that MATCH that is calculated in One.xlsx which will result in 11?
I hope this makes sense to you and I thank anyone in advance for trying to help me.
Bookmarks