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
Patrick2788's avatar
Patrick2788
Silver Contributor
Oct 25, 2019

Andruw 

If it's what I think it is, performing a lookup where there's multiple returns for the same lookup value(s), it's very do-able with INDEX. A sample of the workbook would help.

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

    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)

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

      Andruw1 

      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.

      • 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

Resources