Formula works except for one cell

[rafcaf]

I am using vlookup to pull data from monthly tabs into a 30 day tracking tab.

The formula: =IFERROR(1/(1/VLOOKUP($A32,INDIRECT($I32&"!a$3:g$33"),COLUMNS($A$1:C$1),0)),NA())

works everywhere but the cell C32 in the 30 day tab.

I cannot see any formula differences between C32 - G32 or any for the formulas above it.

[Fluff13]

There's nothing wrong with the formula, you just need to change the cell format to time.

[avk]

Need to change format to Time.
In March25 sheet on 3 March 2025 no any data.
Your Formula is ok