7 Replies Latest reply: May 15, 2014 10:05 AM by adonis _ RSS

    help with lookup across multiple columns

    adonis _

      Hi,

      I was wondering if you guys knew how to do a lookup against data in 2 columns.

       

      What I am trying to do is make a field/column that would have a formula which would say 1) if data is in in the Sole column then it would populate Sole,  2) If data is in the None column then populate None.  3) In cases where data is in both columns then a 3rd criteria to populate it is Shared.

       

      There are two columns used the SOLE      & NONE Columns. (Sample data)

      SOLE     NONE

      1000.000      

                10000.000

                12000.000

                10000.000

                10000.000

                10000.000

                10000.000

                 10000.000

                 10000.000

                30000.000

                20000.000

               35000.000

              10000.000

              30000.000

      300.000         15000.000

       

      when pasting the data there is an issue with blanks so please know that the data for sole between the 1000 and 300 are the only data and the rest is blank, so rather then putting a 0 as that would be misleading, i pasted the data which would be all None Data but looks like Sole due to the forum.  Please help.

      much appreciated

        • help with lookup across multiple columns
          Data Kruncher

          [SIZE=2]SOLE    NONE[/SIZE][/FONT]

          [FONT=Courier New]        1000.000[/FONT][/SIZE]

          [FONT=Courier New]       10000.000[/FONT][/SIZE]

          [FONT=Courier New]       12000.000[/FONT][/SIZE]

          [FONT=Courier New]       10000.000[/FONT][/SIZE]

          [FONT=Courier New]       10000.000[/FONT][/SIZE]

          [FONT=Courier New]       10000.000[/FONT][/SIZE]

          [FONT=Courier New]       10000.000[/FONT][/SIZE]

          [FONT=Courier New]       10000.000[/FONT][/SIZE]

          [FONT=Courier New]       10000.000[/FONT][/SIZE]

          [FONT=Courier New]       30000.000[/FONT][/SIZE]

          [FONT=Courier New]       20000.000[/FONT][/SIZE]

          [FONT=Courier New]       35000.000[/FONT][/SIZE]

          [FONT=Courier New]       10000.000[/FONT][/SIZE]

          [FONT=Courier New]       30000.000[/FONT][/SIZE]

          [SIZE=2]300.000 15000.000[/SIZE][/FONT][/code]

           

          Be sure to use the CODE tags when posting samples to properly handle blanks.

           

          What values do you want for Shared for the last row? I assume 15300, but let's be certain, right?