Aug 28 2020 04:30 AM
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!
Aug 28 2020 03:24 PM
@Teeah
No, it doesn't work on 2D arrays
Aug 29 2020 12:31 AM
@Sergei Baklan Thanks.