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

Troubleshooting

Intersecting Points in Lists or Tables

Q1: My index formula doesn't work when trying to pull up two intersecting points within a list.
A1: Use the Lookup Wizard to help you rewrite formulas with complex INDEX(MATCH cases. (I suggest using this tool as a way to learn indexing and matching formulas as well.)

Complex Formulas

Q1: The formula has become too long to nderstand.
A1: Use named ranges to simplify formulas. (But do this only for ranges that generally don't change.) You also can apply a range that's much longer than the list; as the list grows, the new cells with data will be included in the range.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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