SOLVED

Matching a name to a number

Copper Contributor

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 (Copper Contributor)
Solution

@ashadda 

In D2:

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

Fill down.

1 best response

Accepted Solutions
best response confirmed by ashadda (Copper Contributor)
Solution

@ashadda 

In D2:

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

Fill down.

View solution in original post