I've got a formula that works just fine as follows:
It works beautifully and returns exactly the value on the other page I want. However, what I actually need here is the row of this cell, but I get an error when I try to add the ROW() function in (as follows):
It's not just a simple error displayed in the cell, it won't even let me input the formula and move on. In other words, I'm required to correct the formula so it can calculate properly. The only difference here is the addition of the ROW() function.
Am I missing something about how this function operates?
(I can provide a file if necessary)
Thanks.
Bookmarks