Vlookup

%3CLINGO-SUB%20id%3D%22lingo-sub-2292281%22%20slang%3D%22en-US%22%3EVlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2292281%22%20slang%3D%22en-US%22%3ECan%20someone%20help%20me%2C%20please%3F%3CBR%20%2F%3EI%20am%20new%20to%20vlookup%20formula%20and%20have%20an%20exam%20question%20that%20I%20can%E2%80%99t%20answer.%20It%20is%3A%3CBR%20%2F%3EUsing%20Vlookup%20formula%2C%20return%20template%20employee%20name%20from%20chart%20B%20using%20service%20location%20name%20as%20the%20unique%20identifier%20in%20chart%20A%20in%20a%20new%20column.%3CBR%20%2F%3E%3CBR%20%2F%3EI%E2%80%99ve%20tried%20a%20few%20different%20ways%20but%20not%20sure%20where%20I%E2%80%99m%20going%20wrong.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2292281%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2292366%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2292366%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1036951%22%20target%3D%22_blank%22%3E%40Nicolakill%3C%2FA%3E%26nbsp%3BDifficult%20to%20diagnose%20what's%20wrong%20if%20you%20don't%20show%20what%20formula%20you%20are%20using.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Can someone help me, please?
I am new to vlookup formula and have an exam question that I can’t answer. It is:
Using Vlookup formula, return template employee name from chart B using service location name as the unique identifier in chart A in a new column.

I’ve tried a few different ways but not sure where I’m going wrong.

1 Reply

@Nicolakill Difficult to diagnose what's wrong if you don't show what formula you are using.