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.