Exercises / Lookups · 7 of 10

Return a whole record at once

If the return range is several columns wide, XLOOKUP returns all of them and the result spills to the right. One formula fills the whole record.

Your taskIn H2, use XLOOKUP to look up the employee ID in G2 and return the whole matching row of A2:D9: name, department, ID and email. The result spills into H2:K2.
Pro

Unlock this exercise and every module after the basics.

Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.

See plansI already have Pro
RowABCDEFGHIJK
1NameDepartmentEmployee IDEmailIDNameDepartmentIDEmail
2Arben HoxhaFinanceE-1031arben@northwind.coE-1078
3Bea LindqvistSalesE-1042bea@northwind.co
4Carlos RuizOperationsE-1057carlos@northwind.co
5Dina PetrovaSalesE-1063dina@northwind.co
6Emeka ObiITE-1078emeka@northwind.co
7Fatima ZahraFinanceE-1081fatima@northwind.co
8Goran IlićITE-1094goran@northwind.co
9Hana SatoMarketingE-1102hana@northwind.co