Multi Look up Help

[RLJ]

I need a formula to put in F6 that takes the Investor_Number from A2 and If it is in the Table InvSpec, AND the Event in C6 that corresponds to the Investor_Number is in the Table InvSpec, then return the Instructions Wash With Care.

Book1
	A	B	C	D	E	F
1	Investor Number
2	1234
3
4
5			Event			Instructions
6			Apples			Wash With Care
7
8	Table
9	Investor	Deal	Event	Insrtuctions
10	9876		Pears	Dice
11	5555		Tomatoes	Be Carful
12	1234		Apples	Wash With Care
Sheet1

 

[skillilea]

try this

Book1
	A	B	C	D	E	F
1	Investor Number
2	1234
3
4
5			Event
6			Apples			Wash With Care
7
8	Table
9	Investor	Deal	Event	Insrtuctions
10	9876		Pears	Dice
11	5555		Tomatoes	Be Carful
12	1234		Apples	Wash With Care
Sheet1

Cell Formulas
Range	Formula
F6	F6	=FILTER(InvSpec[Insrtuctions], (InvSpec[Investor] =$A$2) *(InvSpec[Event]=$C$6), "No result")

 

[RLJ]

try this

Book1
	A	B	C	D	E	F
1	Investor Number
2	1234
3
4
5			Event
6			Apples			Wash With Care
7
8	Table
9	Investor	Deal	Event	Insrtuctions
10	9876		Pears	Dice
11	5555		Tomatoes	Be Carful
12	1234		Apples	Wash With Care
Sheet1

Cell Formulas
Range	Formula
F6	F6	=FILTER(InvSpec[Insrtuctions], (InvSpec[Investor] =$A$2) *(InvSpec[Event]=$C$6), "No result")

Thank you. This works perfectly.

 

[skillilea]

Glad to help