Using INDIRECT address for sheet name in XLOOKUP function

[fraz627]

I would like to use and indirect address for the sheet Name in a XLOOKUP Function
the cell with the sheet name will be on the same row as the actual formula Column "M"
Hear is the current formula
"=XLOOKUP(G2,Menu_list!D:D,Menu_list!F:F,C1)" the sheet name will be in cell M2.
Thanks in advance

 

[6StringJazzer]

Try this:

=XLOOKUP(G2, INDIRECT("'" & M2 & "'!D:D"), INDIRECT("'" & M2 & "'!F:F"), C1)

If it does not work please show more detail for how your sheet is laid out.

 

[fraz627]

Thanks that did it!!!!

 

[6StringJazzer]

You're welcome! Please consider Mark as solution