✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
Use VLOOKUP to find the City of Nina:
Name | Department | City | Salary | Bonus |
Karen | Sales | Yerevan | 900 | 120 |
Peter | IT | Gyumri | 1400 | 300 |
Nina | Marketing | Vanadzor | 1100 | 250 |
Aram | IT | Yerevan | 1500 | 310 |
Lucy | Sales | Gyumri | 950 | 140 |
David | Finance | Yerevan | 1250 | 200 |
Sona | Marketing | Yerevan | 1050 | 180 |
Tigran | Finance | Vanadzor | 1300 | 220 |