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

Please see attached for file. 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)

Twifoo's avatar
Twifoo
Silver Contributor
Oct 29, 2019

Andruw1 

I surmise that I must now interpose with this question: 

In your latest attached file, in which cell do you want to create your formula? Once you identify that cell, please state your expected result thereon and the logic thereof. 

Resources