Offset(Address()) Formula "Has an error"

Simple question. The following formula:
=OFFSET(ADDRESS(1,MATCH($A25,$A$1:$HO$1,0),,,),0,2)
is being rejected with the dialogue box "The formula you typed contains an error" appearing. I cannot figure out why.
The address function by itself works fine, returning $B$1 as it should for my case. But when I add the OFFSET(...,0,2) to it, it suddenly gives me this error.
Even though the formula =OFFSET($B$1,0,2) obviously works properly, an address function returning $B$1 does not. Please help.

There are two problem in your formula.
1) you are trying to create single cell range and you have given 0,2 range to pull in offset function.
2) please remove ,,,) section from formula , no need of that.

Regards,
Suhas

I removed the 3 commas, I'm not really sure why I put those there in the first place lol. Thanks for catching that.
But to the first point, I don't quite understand the problem. Isn't it supposed to be one cell that you then move x rows and y columns from? Which is what I'm doing, I'm providing a cell reference (B1) for it to move 0 rows and 2 columns from, to D1.

Try this.

Used indirect function.

=OFFSET(INDIRECT(ADDRESS(1,MATCH($A3,$A$1:$HO$1,0))),1,0)
Regards,
Suhas