XLOOKUP through multiple sheets

[g3org]

Hi everyone,

It any chances to have a return value a range of cells using XLOOKUP function across the multiple sheets?

Now i am using VLOOKUP and it is returning on cell, but I would like more than one cell as once.

Like above, it is possible to have as result the range F32:J42?

Thanks in advance!

 

[Domenic]

Is this what you mean?

=INDIRECT("'"&B1&"'!F32:J42")

 

[g3org]

Is this what you mean?

=INDIRECT("'"&B1&"'!F32:J42")

Yes, it works perfectly. Thank you!

 

[Domenic]

You're very welcome, cheers!