Forum Discussion

Andruw's avatar
Andruw
Copper Contributor
Oct 25, 2019

Higher-End Excel Formula Help

Hello. Working on a massive spreadsheet. Background needed to understand question:   - You have (3) Columns, Column A, B and C - These (3) columns are on Sheet "1" - All three columns have the sa...
excel
Formulas and Functions
Andruw1's avatar
Andruw1
Copper Contributor
Oct 28, 2019

Patrick2788 My apologies - I deleted too much out. Please see updated file w/ the blank Panel Schedule templates. What I need is the PANEL NAME (from PANEL INPUT tab) to be referenced into the space where it says PANEL NAME under the 1Ø or 3Ø PANEL SCHEDULES tab

Patrick2788's avatar
Patrick2788
Silver Contributor
Oct 28, 2019
Does this mean the formula should pull DP12, DP7 and DP20 OR just pull DP12 for that first example in the 30 panel schedules.
  • Andruw1's avatar
    Andruw1
    Copper Contributor
    Oct 28, 2019

    Patrick2788 The latter of two. For DP12, since it is PANEL 1 for the 3Ø 42P template, that would be the name to populate PANEL NAME under the 3Ø PANEL SCHEDULES tab for the 3Ø 42P template.

     

    Side Note: I haven't mass-copied my blank panel schedules templates horizontally to the right. So in theory, if I copied my 3Ø 42P template to the right, DP7 would be the name to fill that second template. I wanted to get the logic down first before making mass-templates.

    • Patrick2788's avatar
      Patrick2788
      Silver Contributor
      Oct 28, 2019

      Andruw1

      Why not use a partial match on the value in B2?

       

      e.g.

       

      =MATCH("*"&LEFT(B2,2)&"*",'PANEL INPUT'!$B$7:$H$7,0)

       

      Feed that into the INDEX.

      • Andruw1's avatar
        Andruw1
        Copper Contributor
        Oct 28, 2019

        Patrick2788 I typed that formula into B2 and I got a return value of 1, is there something else I need? I double checked that my formula was correct. I also tried editing the number value to 7 to include all of "3Ø, 42P"

         

        And the reason why I've tried to do it this way is because Column D "LOAD DESCRIPTION" is the next piece of information I want to have referenced into my PANEL SCHEDULES templates based off the PANEL#, Ø & POLE, PANEL NAME and CIRCUIT#. If I could figure out how to get the PANEL NAME to show, it should be the same logic to populate the LOAD DESCRIPTION as well

Resources