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

      Hello,

       

      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.