Vlookup to add data to another tab

%3CLINGO-SUB%20id%3D%22lingo-sub-1252465%22%20slang%3D%22en-US%22%3EVlookup%20to%20add%20data%20to%20another%20tab%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1252465%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20copy%20the%20account%20id%20data%20from%20the%20account%20ID%20tab%20to%20the%20SF%20tab.%20%26nbsp%3BBut%20my%20Vlookup%20formula%20returns%20%23n%2Fa%26nbsp%3B%3DVLOOKUP(A2%2C'Account%20ID'!A%3AB%2C2%2CFALSE)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20am%20doing%20wrong%20%3F%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAccountID%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-03-25%20at%2015.26.53.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F179400i1CAFAB8E77E4D019%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screenshot%202020-03-25%20at%2015.26.53.png%22%20alt%3D%22Screenshot%202020-03-25%20at%2015.26.53.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E2%80%83SF%20tab%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-03-25%20at%2015.25.28.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F179401i8F1C816C2697696D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screenshot%202020-03-25%20at%2015.25.28.png%22%20alt%3D%22Screenshot%202020-03-25%20at%2015.25.28.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1252465%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1252565%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20to%20add%20data%20to%20another%20tab%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1252565%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F594650%22%20target%3D%22_blank%22%3E%40hermy1%3C%2FA%3E%26nbsp%3BOne%20of%20your%20sets%20of%20network%20IDs%20is%20formatted%20as%20text.%26nbsp%3B%20To%20fix%2C%20type%20a%201%20in%20a%20cell%20not%20formatted%20as%20text%2C%20copy%20it%2C%20select%20the%20column%2C%20and%20Paste%20Special%20%3D%26gt%3B%20Multiply.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello,

 

I am trying to copy the account id data from the account ID tab to the SF tab.  But my Vlookup formula returns #n/a =VLOOKUP(A2,'Account ID'!A:B,2,FALSE)

 

What I am doing wrong ?

Thank you

 

AccountID

Screenshot 2020-03-25 at 15.26.53.png

 

 SF tab

Screenshot 2020-03-25 at 15.25.28.png

1 Reply
Highlighted

@hermy1 One of your sets of network IDs is formatted as text.  To fix, type a 1 in a cell not formatted as text, copy it, select the column, and Paste Special => Multiply.