XLOOK UP

Can I use XLOOK UP across multiple sheets in a workbook?

I know how to use it to work for one sheet but I need it to compare and return in a workbook with 28 sheets.

Thanks!