Home

INDEX formual resolves but #N/A is returned

%3CLINGO-SUB%20id%3D%22lingo-sub-909344%22%20slang%3D%22en-US%22%3EINDEX%20formual%20resolves%20but%20%23N%2FA%20is%20returned%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-909344%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20INDEX%20and%20MATCH%20to%20identify%20a%20cell%20in%20a%20worksheet.%20The%20'Function%20Arguments'%20box%20correctly%20resolves%20the%20function%2C%20which%20it%20reports%20as%20%22LA-294-BU%22%20(a%20part%20number).%20But%20the%20cell%20holding%20the%20formula%20reports%20%23N%2FA.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp%2C%20please!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-909344%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-909396%22%20slang%3D%22en-US%22%3ERe%3A%20INDEX%20formual%20resolves%20but%20%23N%2FA%20is%20returned%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-909396%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F424612%22%20target%3D%22_blank%22%3E%40fernandinamike%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20means%20MATCH%20didn't%20find%20your%20value.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-909410%22%20slang%3D%22en-US%22%3ERe%3A%20INDEX%20formual%20resolves%20but%20%23N%2FA%20is%20returned%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-909410%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%3B%20Thanks.%20But%20the%20Function%20Arguments%20box%20said%20there%20%3CU%3Ewas%3C%2FU%3E%20a%20result%2C%20and%20it%20shows%20it!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMike%3C%2FP%3E%3C%2FLINGO-BODY%3E
fernandinamike
New Contributor

I am using INDEX and MATCH to identify a cell in a worksheet. The 'Function Arguments' box correctly resolves the function, which it reports as "LA-294-BU" (a part number). But the cell holding the formula reports #N/A.

 

Help, please!

3 Replies

@fernandinamike 

That means MATCH didn't find your value.

@Sergei Baklan  Thanks. But the Function Arguments box said there was a result, and it shows it!

 

Mike

Got it!  I was missing the { and } around the array formula. Typing Control, Shift, Enter as a three-fingered salute did the trick.

 

Thanks.

 

@fernandinamike 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies