VLOOKUP help needed

%3CLINGO-SUB%20id%3D%22lingo-sub-2661406%22%20slang%3D%22en-US%22%3EVLOOKUP%20help%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2661406%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20copied%20a%20cell%20with%20VLOOKUP%20formula%20to%20another%20cell%2C%20the%20problem%20is%20that%20in%20the%20new%20cell%20the%20formula%20appears%20and%20not%20the%20result%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2661406%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-2661458%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20help%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2661458%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1131493%22%20target%3D%22_blank%22%3E%40A_klenk_hotmailcom%3C%2FA%3E%26nbsp%3BDifficult%20to%20say%2C%20but%20perhaps%20you%20have%20used%20a%20lookup%20array%20without%20making%20the%20reference%20absolute%2C%20i.e.%20using%20%24%20signs.%20Can%20you%20show%20the%20formula%20you%20are%20using%3F%20Or%20perhaps%20upload%20the%20file%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2661500%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20help%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2661500%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eit%20is%20a%20simple%20Vlookup%20formula%2C%20the%20problem%20is%20that%20it%20is%20in%20a%20file%20that%20was%20provided%20by%20a%20client%2C%20i%20have%20had%20to%20add%20columns%20to%20this%20file%20and%20thus%20duplicated%20the%20formula%20from%20one%20cell%20into%20the%20new%20created%20cell%20in%20new%20column%2C%20for%20some%20reason%20copying%20the%20formula%20does%20not%20show%20the%20result%20but%20shows%20the%20formula%20instead!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

i copied a cell with VLOOKUP formula to another cell, the problem is that in the new cell the formula appears and not the result

 

4 Replies

@A_klenk_hotmailcom Difficult to say, but perhaps you have used a lookup array without making the reference absolute, i.e. using $ signs. Can you show the formula you are using? Or perhaps upload the file?

@Riny_van_Eekelen 

 

it is a simple Vlookup formula, the problem is that it is in a file that was provided by a client, i have had to add columns to this file and thus duplicated the formula from one cell into the new created cell in new column, for some reason copying the formula does not show the result but shows the formula instead!

@A_klenk_hotmailcom Again, difficult to help when you just say that a formula doesn't work (even a simple one) if you don't provide the formula and the context in which it is used.

@A_klenk_hotmailcom 

If in one cell formula returns result and in another cell you see formula itself, most probably second cell is formatted as text. Apply General format and re-enter the formula.