FIXED FUNTION

Hello WINCANTON​, 

The issue comes from the field argument in your DGET formula. In newer versions of Excel, DGET is stricter: the field must be either the exact column header text or a column number.

Right now you’re using:

=DGET($A$4:$J$90, FIXED(B96,1,0), $A$2:$A$3)

FIXED() always returns text, which won’t match your column headers unless they are literally formatted numbers. That’s why you’re now getting #VALUE!.

Fixes:

• If B96 contains the column header name, just use it directly: =DGET($A$4:$J$90, B96, $A$2:$A$3)
• If B96 contains a column number, use it directly (or wrap with INT() if needed): =DGET($A$4:$J$90, INT(B96), $A$2:$A$3)
• If you want to hard‑code, you can also pass the header name as text: =DGET($A$4:$J$90, "Sales", $A$2:$A$3)

In short: remove FIXED(). Use either the header name or the column index, and the formulas will work again in the updated Office.

WorksheetFunction.DGet method (Excel)

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.