SOLVED

Matching a name to a number

%3CLINGO-SUB%20id%3D%22lingo-sub-2835899%22%20slang%3D%22en-US%22%3EMatching%20a%20name%20to%20a%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2835899%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI'm%20trying%20to%20match%20the%20points%20per%20game%20(PPG)%20on%20the%20right%20hand%20side%20of%20the%20spreadsheet%20to%20the%20player's%20name%20on%20the%20left%20hand%20side%20of%20the%20worksheet%2C%20with%20the%20results%20being%20placed%20in%20column%20D.%20I'm%20a%20little%20new%20to%20excel%20so%20any%20help%20is%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2835899%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-2836056%22%20slang%3D%22en-US%22%3ERe%3A%20Matching%20a%20name%20to%20a%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2836056%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1182538%22%20target%3D%22_blank%22%3E%40ashadda%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20D2%3A%3C%2FP%3E%0A%3CP%3E%3DVLOOKUP(B2%2C%24G%3A%24I%2C3%2CFALSE)%3C%2FP%3E%0A%3CP%3EFill%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

I'm trying to match the points per game (PPG) on the right hand side of the spreadsheet to the player's name on the left hand side of the spreadsheet, with the results being placed in column D. I'm a little new to excel so any help is appreciated!

1 Reply
best response confirmed by ashadda (Occasional Visitor)
Solution

@ashadda 

In D2:

=VLOOKUP(B2,$G:$I,3,FALSE)

Fill down.