Numbers formula corrupted since update

I can't work out the flow from the screenshots posted...

You reference a 'Jobs sheet', but I don't know where that is (if at all) in the above sheets.

I also don't know what you're seeing wrong... Clearly you know, from experience, what this sheet should look like, but without that knowledge I can't tell what cells might be at fault.

Without knowing that it's hard to know where to start. If I had to take a stab in the dark, I'd point at the @ in the @ INDEX() part of the formula - @ references were only added in Numbers 14.4, so could not have been part of the original formula. Numbers usually intuits whether to add the @ sign or not to older Numbers files, but it may be this is a case where it got it wrong. Does the sheet work if you remove the @?

Studsy26 wrote:

The issue I have is when I input the data into the a main sheet it populates the whole table in my job sheets by duplicating the data which should be one row.

I've taken the @ out, it makes no difference. This has only started to happen after the recent update.

The populating of the whole table likely results from the new "dynamic array" or "spilling" behavior in the latest Numbers, similar to modern versions of Excel.

The INDEX MATCH typically looks up a value somewhere else in the document. In modern versions it can return a multiple values instead of just one. Its simpler modern equivalent, XLOOKUP, can also return multiple values.

It is difficult to see how to modify your old formula without understanding the specifics of the ranges to which it refers and what you expect the results to be. You do not seem to have 'Job' table in your screenshots. It would help if you could give a specific example including that, and the result you expect.

SG