XLOOK UP

Copper Contributor

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!

2 Replies

@Teeah 

No, it doesn't work on 2D arrays

@Sergei Baklan Thanks.