Home

vlookup from another sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-808805%22%20slang%3D%22en-US%22%3Evlookup%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-808805%22%20slang%3D%22en-US%22%3E%3CP%3Ewhen%20i%20try%20to%20use%20vlookup%20formula%20by%20using%20another%20sheet%20then%20i%20am%20getting%20the%20error%20%23NA%23%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-808805%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-808898%22%20slang%3D%22en-US%22%3ERe%3A%20vlookup%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-808898%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F393679%22%20target%3D%22_blank%22%3E%40ramakrishna90%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20share%20an%20example%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-809364%22%20slang%3D%22en-US%22%3ERe%3A%20vlookup%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-809364%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F393679%22%20target%3D%22_blank%22%3E%40ramakrishna90%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20doesn't%20matter%20you%20VLOOKUP%20on%20the%20same%20or%20another%20sheet.%20Main%20reasons%20for%20%23NA%20error%20with%20VLOOKUP%20are%20described%20here%26nbsp%3B%3CA%20title%3D%22How%20to%20correct%20a%20%23N%2FA%20error%20in%20the%20VLOOKUP%20function%22%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fhow-to-correct-a-n-a-error-in-the-vlookup-function-e037d763-ffc3-4fae-a909-89c482d389b2%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EHow%20to%20correct%20a%20%23N%2FA%20error%20in%20the%20VLOOKUP%20function%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-809427%22%20slang%3D%22en-US%22%3ERe%3A%20vlookup%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-809427%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F393679%22%20target%3D%22_blank%22%3E%40ramakrishna90%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3ENaming%20the%20%22Table%20Array%22%20makes%20it%20easier%20and%20less%20error%20prone%20when%20creating%20a%202%20dimensional%20function%20(like%20the%20one%20you%20are%20talking%20about).%3C%2FP%3E%3CP%3ENaming%20is%20as%20easy%20as%20selecting%20the%20Table%20array%20and%20typing%20any%20name%20of%20your%20choice%20(No%20Spaces)%20in%20the%20Name%20Box%20(to%20the%20left%20side%20of%20the%20Formula%20Bar)%20followed%20by%20hitting%20ENTER%20(for%20the%20name%20to%20stick)%3C%2FP%3E%3CP%3EGood%20luck%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
ramakrishna90
Occasional Visitor

when i try to use vlookup formula by using another sheet then i am getting the error #NA#

3 Replies
Highlighted

Hello @ramakrishna90,

 

Can you share an example?

Highlighted

@ramakrishna90 

It doesn't matter you VLOOKUP on the same or another sheet. Main reasons for #NA error with VLOOKUP are described here How to correct a #N/A error in the VLOOKUP function

Highlighted

@ramakrishna90 

Hi

Naming the "Table Array" makes it easier and less error prone when creating a 2 dimensional function (like the one you are talking about).

Naming is as easy as selecting the Table array and typing any name of your choice (No Spaces) in the Name Box (to the left side of the Formula Bar) followed by hitting ENTER (for the name to stick)

Good luck

Nabil Mourad

Related Conversations
pull data based on dropdown list
bbombb in Excel on
1 Replies
Vlookup formula - partial text search
fredericomarquez in Excel on
2 Replies
URGENT Excel question HELP
RileyCDeason in Excel on
1 Replies
Need FORMULA help please!!
marislav in Excel on
4 Replies
Sum of Vlookup results
dleesBLX in Excel on
1 Replies