The file named Lookupmultiplecolumns.xlsx contains information about several sales made at an electronics store. A salespersons name

Question:

The file named Lookupmultiplecolumns.xlsx contains information about several sales made at an electronics store. A salesperson’s name is entered in B17. Write an Excel formula that can be copied from C17 to D17:F17 that will extract that salesperson’s radio sales to C17, TV sales to D17, printer sales to E17, and CD sales to F17.


image

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: