1 Reply Latest reply on Oct 6, 2016 4:56 PM by Patrick A Van Der Hyde

    Using LOOKUP to only show rows that contain values in all columns

    John Brink



      I wanted to share with you a LOOKUP calcuation that I've worked on that allows me to perform the functionality below. Might be very helpful to those here, especially if you're  working with bigger datasets





      Now with the lookup function and pointing it to the RELATIVE TO value, I can make the sheet only show the companies

      that attended both conferences.