I am using a spreadsheet with 3 different tabs for various data items.
On tab 1, I'm using the following formula:
HYPERLINK("#"&CELL("address",INDEX(Table2[Investor],LEFT(G8, FIND(",",G8&",")-1)-ROW(Table2[[#Headers],[Investor]]))),"Go to Row")
this works great. If I click "go to row" it takes me to the row where the data I was looking for is.
On Tab 2, i'm using the same formula with a different data set. Here it is below:
HYPERLINK("#"&CELL("address",INDEX(Table22[[#All],[Name]],LEFT(G9, FIND(",",G9&",")-1)-ROW(Table22[[#All],[Name]]))),"Go to Row")
This results in a spill error. I don't know why - and I can see the data it is selecting as obstructing (Column H, rows 12-54) which I'm not even sure how it's getting over there.
help?
Brad
On tab 1, I'm using the following formula:
HYPERLINK("#"&CELL("address",INDEX(Table2[Investor],LEFT(G8, FIND(",",G8&",")-1)-ROW(Table2[[#Headers],[Investor]]))),"Go to Row")
this works great. If I click "go to row" it takes me to the row where the data I was looking for is.
On Tab 2, i'm using the same formula with a different data set. Here it is below:
HYPERLINK("#"&CELL("address",INDEX(Table22[[#All],[Name]],LEFT(G9, FIND(",",G9&",")-1)-ROW(Table22[[#All],[Name]]))),"Go to Row")
This results in a spill error. I don't know why - and I can see the data it is selecting as obstructing (Column H, rows 12-54) which I'm not even sure how it's getting over there.
help?
Brad