Text based formulae over spreadsheets not giving expected result

[Starter24]

Question
I have two spreadsheets Sheet1 and Sheet2. If I reference the value required using a concetenated formula, I do not get the expected result. The cells are not formatted as text, the cells are not set to "show “formula”, neither was the spreadsheet a CSV or Txt file previously.

On Sheet1 I used “=+ CONCAT("$";A3;".G";C3) ( A3 is 22; $Sheet2.G22 is 5 Minutes)
Result +$Sheet2.G22 ( in green due to highlighting formula)
Req’d 5:00:00 or some decimal fraction

On Sheet1 I used “=+ OFFSET("$"&A3&".G"&C3;0;0)
but got the error 504
If I use the formula =+$Sheet2.G22 (in green due to highlighting formula)
I obtain the correct result 05:00:00

Before I gave Excel away, these types of formula required evaluation, I believe with NUMBERVALUE or similar. I have tried several alternatives with OFFSET, MATCH in LO over the spreadsheets but these do not seem to work either. Most likely the problem has occurred many times before.

Is there something simple that I am overlooking?

LO Version: 24.2.4.2 (X86_64) / LibreOffice Community
Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: de-DE (en_DE); UI: en-GB
Calc: CL threaded

[mariosv]

Not possible referencing in that way, using text strings as addresses.
There is a function for that.
INDIRECT()
INDIRECT(CONCAT("$";A3;".G";C3))
or
INDIRECT("$"&A3&".G"&C3)

[karolus]

@mariosv

INDIRECT("$"&A3&".G"&C3)

$-signs have no effect in the context of INDIRECT … drop it!

=INDIRECT(A3&".G"&C3)
=INDIRECT(CONCAT(A3;".G";C3))

[Starter24]

Thanks mariosv.
Simple but I did not see it after many hours of debating whether a space , plus signor alternative strings etc. could be the root of the problem.
Also thanks for the early reply!