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...
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.
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)