I have a formula I've been using forever now - basically anytime I need to add info from sheet 2 to sheet one based on a matched comparison.
My formula is: =IFERROR(INDEX(PT[HR Pay Tech Name],MATCH([@Unit],PT[Unit '#],0)),"")
I've kept this formula on a windows sticky note so I can copy and paste it whenever I need it. I'll modify it as needed, but I kept it there so I didn't have to remember it.
However, recently whenever I copy it from the sticky note to excel I'm getting the spill error and then the results are appearing below my table.
Any idea how to correct this?
Bookmarks