SOLVED

VLook up help

%3CLINGO-SUB%20id%3D%22lingo-sub-2280040%22%20slang%3D%22en-US%22%3EVLook%20up%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280040%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%20I%20have%20a%20vendor%20spendsheet%20on%20Sheet1.%26nbsp%3B%20On%20Sheet1%20I%20have%20just%20the%20vendor%20number%20but%20would%20like%20the%20vendor%20name%20as%20well%20-%20taken%20from%20Sheet2.%26nbsp%3B%20%26nbsp%3BI%20have%20very%20basic%20Vlookup%20skills%20and%20its%20just%20returning%20%23na%20in%20column%20B%20on%20sheet1.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2280040%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-2280132%22%20slang%3D%22en-US%22%3ERe%3A%20VLook%20up%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280132%22%20slang%3D%22en-US%22%3EYou're%20welcome%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1032615%22%20target%3D%22_blank%22%3E%40helsbrooks1981%3C%2FA%3E!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2280082%22%20slang%3D%22en-US%22%3ERe%3A%20VLook%20up%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280082%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1032615%22%20target%3D%22_blank%22%3E%40helsbrooks1981%3C%2FA%3E%26nbsp%3BYou're%20welcome!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2280078%22%20slang%3D%22en-US%22%3ERe%3A%20VLook%20up%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280078%22%20slang%3D%22en-US%22%3EThank%20you%20very%20much%20that%20works%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2280077%22%20slang%3D%22en-US%22%3ERe%3A%20VLook%20up%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280077%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3Bthank%20you%20very%20much%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2280076%22%20slang%3D%22en-US%22%3ERe%3A%20VLook%20up%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280076%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20that%20works%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2280070%22%20slang%3D%22en-US%22%3ERe%3A%20VLook%20up%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280070%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1032615%22%20target%3D%22_blank%22%3E%40helsbrooks1981%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%20if%20you%20don't%20want%20to%20change%20the%20data%20type%20of%20the%20column%20A%20on%20Sheet1%20for%20some%20reason%2C%20you%20may%20simply%20try%20the%20following%20formula....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20Sheet1%3C%2FP%3E%3CP%3EIn%20B2%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DVLOOKUP(A2%2B0%2CSheet2!A%3AB%2C2%2C0)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20then%20copy%20it%20down.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2280056%22%20slang%3D%22en-US%22%3ERe%3A%20VLook%20up%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280056%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1032615%22%20target%3D%22_blank%22%3E%40helsbrooks1981%3C%2FA%3E%26nbsp%3BThe%20vendor%20number%20on%20Sheet1%20are%20in%20fact%20texts%2C%20whereas%20they%20are%20real%20numbers%20on%20Sheet.%20On%20top%20of%20that%2C%20you%20switched%20some%20of%20the%20arguments%20in%20the%20VLOOKUP%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFixed%20that%20in%20the%20attached%20file.%20See%20if%20this%20is%20what%20you%20expect.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi - I have a vendor spendsheet on Sheet1.  On Sheet1 I have just the vendor number but would like the vendor name as well - taken from Sheet2.   I have very basic Vlookup skills and its just returning #na in column B on sheet1.

7 Replies
best response confirmed by helsbrooks1981 (New Contributor)
Solution

@helsbrooks1981 The vendor number on Sheet1 are in fact texts, whereas they are real numbers on Sheet. On top of that, you switched some of the arguments in the VLOOKUP formula.

 

Fixed that in the attached file. See if this is what you expect.

@helsbrooks1981 

 

Or if you don't want to change the data type of the column A on Sheet1 for some reason, you may simply try the following formula....

 

On Sheet1

In B2

 

=VLOOKUP(A2+0,Sheet2!A:B,2,0)

 

and then copy it down.

 

Thank you that works @Subodh_Tiwari_sktneer 

@Subodh_Tiwari_sktneer thank you very much

Thank you very much that works

@helsbrooks1981 You're welcome!

You're welcome @helsbrooks1981!