Best Practice

Discussion List

• Using a nested IF to determine a range

  In Best Practice

  Here's a little tid-bit I just figured out today... You can use a nested IF statement to output ranges/cross sheet references that are to be evaluated. The particular use case that led to this was an INDEX/MATCH where we wanted to INDEX o…

  Paul Newcome

  07/23/21

  121 6

  121 views 6 comments 6 points Most recent by L_123 07/23/21Best Practice