Excel for Data Analysis and Visualization

Lookup across rows and columns (at the same time)

You don’t have access to this lesson

Please purchase this course, or sign in if you’re already enrolled, to access the course content.

Lookup across rows and columns (at the same time)

  • In D26, D27, M26 & M25 use MATCH to get the correct reference number from the information in B26, B27, K26, K27
  • Link M28 directly to K28
  • In B30 and K30 use Index to get the correct number

To see the full course contents click here.

0 of 141 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop