Forum Discussion
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...
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.