Fragen ID: 1246 10/19
PREVIOUS QUESTION NEXT QUESTION

The cell range G3:H8 displays teams and countries of origin. Insert a function in the cell D2 to return the country name for the specific team. Then, reproduce the function in the cell range D3:D21. Use the VLOOKUP function

 

 

Other versions
Microsoft Excel 2003Microsoft Excel 2007Microsoft Excel 2010Microsoft Excel 2013Microsoft Excel 2016Microsoft Excel 365

 

 

 


The cell range G3:H8 displays teams and countries of origin. Insert a function in the cell D2 to return the country name for the specific team. Then, reproduce the function in the cell range D3:D21. Use the VLOOKUP function