KEMBAR78
Spreadsheet Task Part 1 - Extension (Lookup) | PDF | Forward (Association Football) | Fc Barcelona
Scribd
Upload
161 views4 pages

Spreadsheet Task Part 1 - Extension (Lookup)

The document contains a table with player data including position code, position, player name, club, goals scored, and assists for various soccer players in different leagues. It demonstrates using VLOOKUP to lookup values from the table based on position code, player name, or club and return the corresponding data to the right of the lookup value, such as returning position for a given position code or goals scored for a given player name.

Uploaded by

Student Pearl Mathew
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
161 views4 pages

Spreadsheet Task Part 1 - Extension (Lookup)

The document contains a table with player data including position code, position, player name, club, goals scored, and assists for various soccer players in different leagues. It demonstrates using VLOOKUP to lookup values from the table based on position code, player name, or club and return the corresponding data to the right of the lookup value, such as returning position for a given position code or goals scored for a given player name.

Uploaded by

Student Pearl Mathew
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Vlookup (Vertical) - Part 2

Position Code Position Player Name Club Goals Scored


GK David de Gea Man Utd
MF Sergio Busquets Barcelona
GK Manuel Neuer Bayern Munich
The Range

MF David Silva Man City


FW Zlatan Ibrahimovic PSG
MF Xabi Alonso Real Madrid
MF Yaya Toure Man City
MF Mesut Ozil Arsenal
CB Gerard Pique Barcelona
FW Radamel Falcao Monaco
FW Franck Ribery Bayern Munich
CB Sergio Ramos Real Madrid
art 2
Assits League
Position Code Position Player Name Club Goals Scored Assits
GK Goal Keeper David de Gea Man Utd 0 0
FW Forward Lionel Messi Barcelona 35 10
FW Forward Cristiano Ronaldo Real Madrid 45 13
MF Midfielder Xavi Barcelona 3 9
MF Midfielder Andres Iniesta Barcelona 12 5
FW Forward Zlatan Ibrahimovic PSG 29 15
FW Forward Radamel Falcao Monaco 23 4
FW Forward Robin van Persie Man Utd 14 12
MF Midfielder Andrea Pirlo Juventus 5 10
MF Midfielder Yaya Toure Man City 6 12
FW Forward Edinson Cavani PSG 23 9
FW Forward Sergio Aguero Man City 35 15
GK Goal Keeper Iker Casillas Real Madrid 0 0
FW Forward Neymar Barcelona 12 9
MF Midfielder Sergio Busquets Barcelona 7 4
MF Midfielder Xabi Alonso Real Madrid 5 6
CB Centre back Thiago Silva PSG 3 0
MF Midfielder Mesut Ozil Arsenal 6 17
MF Midfielder David Silva Man City 3 14
MF Midfielder Bastian Schweinsteiger Bayern Munich 6 14
GK Goal Keeper Gianluigi Buffon Juventus 0 0
FW Forward Luis Suarez Liverpool 38 14
CB Centre back Sergio Ramos Real Madrid 0 0
CB Centre back Vincent Kompany Man City 4 0
CB Centre back Gerard Pique Barcelona 5 0
RB Right Back Philipp Lahm Bayern Munich 5 9
MF Midfielder Willian Chelsea 7 4
FW Forward Franck Ribery Bayern Munich 12 12
GK Goal Keeper Manuel Neuer Bayern Munich 0 0
League Lookup Value Output
Premier League 1 Position Code Position
La Liga 2 Player Name Goals Scored
La Liga 3 Player Name Assists
La Liga 4 Club League
La Liga
Ligue 1
Ligue 1
The output form the lookup
Premier League should always be to the Right of
serie a the lookup value.
Premier League
Ligue 1
Premier League
La Liga
La Liga
La Liga
La Liga
Ligue 1
Premier League
Premier League
Bundesliga
serie a
Premier League
La Liga
Premier League
La Liga
Bundesliga
Premier League
Bundesliga
Bundesliga

You might also like