Get cell Value from different sheet (='Sheetname'!CellAdresse), but the sheet name has to be taken from 5digits+text from collumn B

[mysticmario]

Basically the title sums it up here's a screen shot showing collumn B which has 5 digits which correspond to a sheet name 5 digits+"Godziny". in collumn I i wnat to have a value from cell G59 of that sheet.
Is there a way to ue formula, or I need to use VBA for that?

 

[Fluff]

How about

=INDIRECT("'Godziny"&LEFT(B2,5)&"'!G59")

 

[6StringJazzer]

I was going to suggest what Fluff shows, but how did you get G59? You may need a different formula to be able to copy and paste it to different rows.

 

[mysticmario]

How about

=INDIRECT("'Godziny"&LEFT(B2,5)&"'!G59")

excel throws an error at (B2,5) - incorrect formula

 

[mysticmario]

Still same problem
even though I tried different version of your code. I get the idea behind it, but something goes south when I try to apply it.
Also why &"'G59")? when i just want valud from this cell in that ("'Godziny"&LEFT(B2,5) sheet?

 

[Fluff]

You will probably need to change the commas to semi-colons.
Also what language version are you using?

 

[mysticmario]

You will probably need to change the commas to semi-colons.
Also what language version are you using?

I tried semi-colons even before u said coz it's a known issue. I used PL version of excel however it was able to execute code in ENG I often time mix those 2

 

[mysticmario]

I made it, your given code was ok, for the first time ever I needed to translate this into PL,. I also used wrong syntax for LEFT in PL.
Thank you for your assitance

 

[Fluff]

Glad you sorted it & thanks for the feedback.