Best Practice

Archives for May 2021

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…
    121 6
    121 views 6 comments Most recent by L_123 Best Practice