79647071

Date: 2025-05-31 23:50:38
Score: 1.5
Natty:
Report link
=XLOOKUP(Analysise!B2,INDIRECT("'"&B3&"'!$B:$B"),INDIRECT("'"&B3&"'!$A:$G"))

This formula works in my sample file with the dropdown for the sheet name in cell B3 of sheet "Analysise".

Result for "Background" in cell B3:

enter image description here

Result for "sheet2" in cell B3:

enter image description here

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: user22566114