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)