FIXED FUNTION

If you want to refer to a column number, do NOT use FIXED.

Replace:

FIXED(B96;1;0)

With:

B96

Final correct formula:

=DGET($A$4:$J$90;B96;$A$2:$A$3)

Works in all current Excel versions
No #VALUE!
Proper numeric field reference

Alternative fix (if you need header text)

If B96 corresponds to a column header, then use TEXT, not FIXED:

=DGET($A$4:$J$90;TEXT(B96;"0");$A$2:$A$3)

But this only works if the result exactly matches a column header.

Summary

Cause: Office update enforces correct data types
Problem: FIXED() returns text → DGET rejects it
Solution:
Use B96 directly
Or use ROUND() instead of FIXED()

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and like it!

This will help all forum participants.

First, please stop shouting (i.e., don't use ALL CAPS, which is widely regarded as the visual equivalent of shouting); it doesn't make things any more urgent,

Second, you are making a very sweeping claim: "All my formulas", although you only show one formula, and your title refers very specifically to the FIXED function, which is pretty non-universal. So maybe slow down, lower your voice just a bit, and be more precise in describing what you're experiencing, as well as providing more examples if indeed it is "all" of your formulas.

Third: here's a link to a resource that may point you in the right direction for resolving the error on your own.

Fourth: if it's only formulas that involve the FIXED function, it may be that you're using it thinking it returns a numeric value, but in fact it returns a number as text.