Forum Discussion
Teeah
Aug 28, 2020Copper Contributor
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!
SergeiBaklan
Aug 28, 2020Diamond Contributor
No, it doesn't work on 2D arrays
- TeeahAug 29, 2020Copper Contributor
SergeiBaklan Thanks.