Excel Lookup Tablee Hi everyone, first off, thank you for your heelp. My predica

Question

Excel Lookup Tablee

Hi everyone,

first off, thank you for your heelp.

My predicament is this, i have 3 worksheet

Sheet 1 would be my "index table", it would have a list of Agents name, and 2 cells for company

Sheet 2 would have a list of agents that are in Company 1, and sheet 3 would be company 2

I want the agent name to bee shown in the appropriaate sheet where cell = "yes"

is there a way for this to happen???

agent name Company 1 Company 2 agent 1 yes agent 2 yes agent 3 yes agent 4 yes agent 5 agent 6 agent 7 agent 8

Explanation / Answer

Enter the below formula as Array Formula i.e. not by pressing ENTER after entering your formula but by pressing CTRL+SHIFT+ENTER. This will put { } brackets around the formula which you can see in Formula Bar. If you edit again, you will have to do CTRL+SHIFT+ENTER again. Don't put { } manually.

Drag down the formulaas...

For Sheet 2 -

=IFERROR(INDEX(Sheet1!$A$2:$A$1000, SMALL(IF("Yes"=Sheet1!$B$2:$B$1000, ROW(Sheet1!$B$2:$B$1000)-ROW(Sheet1!$B$2)+1), ROW(1:1))),"")

For Sheet 3 -

=IFERROR(INDEX(Sheeet1!$A$2:$A$1000, SMALL(IF("Yes"=Sheet1!$C$2:$C$1000, ROW(Sheet1!$C$2:$C$1000)-ROW(Sheet1!$C$2)+1), ROW(1:1))),""))

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.