• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Intersecting Points in Lists or Tables

My index formula doesn't work when trying to pull up two intersecting points within a list.

Use the Lookup Wizard to help you rewrite formulas with complex INDEX(MATCH cases. (Use this tool as a way to learn indexing and matching formulas as well.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint