SOLVED

Excel Error #N/A

%3CLINGO-SUB%20id%3D%22lingo-sub-2282468%22%20slang%3D%22en-US%22%3EExcel%20Error%20%23N%2FA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282468%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20doing%20a%20course%20in%20excel%20and%20is%20following%20the%20instructions%20to%20a%20T.%26nbsp%3B%20But%20after%20as%20instuckted%20to%20put%20%24%20signs%20in%20the%20selector%20cell%20bar%20and%20drag%20it%20down.%26nbsp%3B%20It%20gives%20me%20errors.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20add%20the%20customers%20info%20on%20sheet%202%2C%26nbsp%3B%20sometimes%20it%20even%20works%20on%20the%20second%20line%20but%20not%20any%20further.%26nbsp%3B%20with%20a%20little%20green%20corner%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2282468%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2282555%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Error%20%23N%2FA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282555%22%20slang%3D%22en-US%22%3E%3CP%3Edon't%20worry%20figured%20it%20out.....%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2282547%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Error%20%23N%2FA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282547%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1034844%22%20target%3D%22_blank%22%3E%40Sandra_Ludick%3C%2FA%3E%26nbsp%3BHave%20sent%20you%20a%20DM%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2282540%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Error%20%23N%2FA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282540%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1034844%22%20target%3D%22_blank%22%3E%40Sandra_Ludick%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20it%20is%20at%20all%20possible.%26nbsp%3B%20I%20would%20like%20to%20mail%20you%20my%20excel%20sheet%20then%20I%20can%20explain%20to%20you%20what%20is%20happening.%26nbsp%3B%20It%20seems%20that%203%20of%20the%20cells%20has%20some%20sort%20of%20value%20in%20that%20I%20can't%20get%20rid%20of.%26nbsp%3B%20Thank%20you%20very%20much%20for%20your%20reply.%26nbsp%3B%20Much%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2282509%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Error%20%23N%2FA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282509%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1034844%22%20target%3D%22_blank%22%3E%40Sandra_Ludick%3C%2FA%3E%26nbsp%3BNot%20sure%20what%20you%20are%20trying%20to%20achieve%2C%20but%20when%20you%20put%20the%20dollar%20signs%20in%20the%20lookup%20range%20as%20well%20you%20will%20get%20a%20result.%20But%20it%20will%20be%20the%20same%20for%20all%20as%20rows%20as%20the%20lookup%20value%20(A7)%20is%20also%20fixed%20by%20the%20dollar%20signs.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DVLOOKUP(%24A%247%2CCustomers!%24A%242%3A%24G%244%2C2%2CFALSE)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I am doing a course in excel and is following the instructions to a T.  But after as instuckted to put $ signs in the selector cell bar and drag it down.  It gives me errors.

 

I am trying to add the customers info on sheet 2,  sometimes it even works on the second line but not any further.  with a little green corner 

4 Replies

@Sandra_Ludick Not sure what you are trying to achieve, but when you put the dollar signs in the lookup range as well you will get a result. But it will be the same for all as rows as the lookup value (A7) is also fixed by the dollar signs.

=VLOOKUP($A$7,Customers!$A$2:$G$4,2,FALSE)

 

@Sandra_Ludick 

 

If it is at all possible.  I would like to mail you my excel sheet then I can explain to you what is happening.  It seems that 3 of the cells has some sort of value in that I can't get rid of.  Thank you very much for your reply.  Much appreciated.

@Sandra_Ludick Have sent you a DM

best response confirmed by Sandra_Ludick (Occasional Contributor)
Solution

don't worry figured it out.....