XLOOK UP

%3CLINGO-SUB%20id%3D%22lingo-sub-1618407%22%20slang%3D%22en-US%22%3EXLOOK%20UP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1618407%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20I%20use%20XLOOK%20UP%20across%20multiple%20sheets%20in%20a%20workbook%3F%3C%2FP%3E%3CP%3EI%20know%20how%20to%20use%20it%20to%20work%20for%20one%20sheet%20but%20I%20need%20it%20to%20compare%20and%20return%20in%20a%20workbook%20with%2028%20sheets.%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1618407%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1620224%22%20slang%3D%22en-US%22%3ERe%3A%20XLOOK%20UP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1620224%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F450600%22%20target%3D%22_blank%22%3E%40Teeah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENo%2C%20it%20doesn't%20work%20on%202D%20arrays%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1620527%22%20slang%3D%22en-US%22%3ERe%3A%20XLOOK%20UP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1620527%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional 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
Highlighted

@Teeah 

No, it doesn't work on 2D arrays

Highlighted

@Sergei Baklan Thanks.