Question: VLOOKUP, XLOOKUP ) , what function can be used in cell E 5 to find the unit sales of the person selected in cell E

VLOOKUP, XLOOKUP), what function can be used in cell E5 to find the unit sales of the person selected in cell E4?(You should assume that the range A1:B20 has been named performance.)
\table[[H,A,B,C,D,E],[1,Sallesperson,\table[[Lawn],[Treatments],[Sold]],,,],[2,John,65,,,],[3,Jake,65,,,],[4,Jill,110,,Name,Harry],[5,Eric,74,,Units Sold,],[6,Alex,68,,,],[7,Alan,100,,,],[8,Derek,81,,,],[9,Hal,93,,,],[10,Harry,54,,,],[11,Jan,92,,,],[12,Carol,86,,,],[13,Vivian,79,,,],[14,Jennifer,94,,,],[15,Gregory,58,,,],[16,Dan,52,,,],[171,Max,84,,,],[18,Bob,64,,,],[19,Jeff,51,,,],[20,Wanda,73,,,],[21,(ty,,,,]]
= INDEX (B1:B20,MATCH(E4,A2:A20,0))
 VLOOKUP, XLOOKUP), what function can be used in cell E5 to

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!