A1:A10 May contain values found in range E1:E10.
Formula In Cell B2: If A2 contains a value from range E1:E10, then reference the value from A1.
I'm having difficulty figuring out a formula to accomplish this.
Formula In Cell B2: If A2 contains a value from range E1:E10, then reference the value from A1.
I'm having difficulty figuring out a formula to accomplish this.