Not sure why this formula is not working but would love some feedback.........
I have 2 exactly same data tables which I pull from a different source via power query. The only difference is that one displays horizontally and the other vertically. This is being done so users have option to filter data as needed.
On Horizontal_view table, users can fill in comments for each incident in Column N. I would like corresponding comments to display in row 7 below Vertical_view table. However my index formula returns #value error but not sure why.......
Bookmarks