Forum Discussion
data tables & index/match function
As of yesterday, when I create a data table within a Excel 365 file & use that table within an index/match function, when I hit enter, the formula is looking for an external source & never had to do ...
This reply is not relevant anymore
See reposted question re: data tables & index/match function
HansVogelaar Hello all! I wasn't aware you (rservice0320) had re-posted the question and to avoid duplicates, I have merged these two threads. Sorry for any confusion!
- except if you break the link, the formula is changed into a value which is what I don't want to happen. I still need the index match formula to work. So, unfortunately, breaking it doesn't solve my issue.
See the attached version. I hope the formulas in it do what you want. you'll see that they are structured differently from what you had,
