Forum Discussion
Higher-End Excel Formula Help
Patrick2788 please see attached. I want to return the PANEL NAME based off the PANEL NUMBER and PHASE & POLE. It looks like I can't use and AND statements with multiple VLOOKUP functions in it, but I'm not sure how INDEX will work when the NUMBER and PHASE & POLE changes (need to have PANEL NAME show up on other tabs)
It's possible to avoid use of AND logic and modify the VLOOKUP to handle multiple criteria in lookup and table array if needed. I'm not clear on where (Sheet and cell) you need this formula.
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
- Does this mean the formula should pull DP12, DP7 and DP20 OR just pull DP12 for that first example in the 30 panel schedules.
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.