I am copying sheet1-->Table column values to sheet2 using Index Match formula, which works quite fine.
But issue is only when I delete the source row i.e. Sheet1-->Table-->Row.
Because of deletion I do get #ref error in sheet2.Enclosing excel for your reference.
In sample file:
1. when I try to delete row which is referenced in sheet2 index match formula, I am getting #ref error.
Looking forward to hearing form you.