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 ...
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.
I do not see a drop down menu to remove this "best response".
rservice0320 Hello! Here's the image of how you remove a best response.
Of course, only the author of the original post (such as yourself in this case) can mark best response or remove it, along with MVPs and employees.
I hope that helps for the future!
