Hi
I have built a spreadsheet with a large data table using Index / Match formulas eg =INDEX(Workings!$GC$10:$GC$50,MATCH($C46,Workings!$R$10:$R$50,0),FALSE)
When I try to sort the table the formulas do not follow and the table is wrong. Any ideas how I can fix this so that I can sort the data?
Thanks