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 |