Match() and Index() Functions in Excel - Thorough Explanation
9:57
Added: 3 years ago
From: ExcelisHell
Views: 14,773
Sort by time | Sort by thread (beta)

Link to this comment:

Share to:
see all

All Comments (1)

Sign In or Sign Up now to post a comment!

  • You can imbed the MATCH() function within the INDEX() function also. Like this:

    INDEX(G2:J13,MATCH(B3,F2:F13,0­),MATCH(B2,G1:J1,0)).

    Please dont mind the cell references here.

    skmytid 2 years ago

View all Comments »
Loading...
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more