cvgalloway
Technical User
Here is my data:
A1 A
A2 B
A3 C
A4 D
B1 1
B2 2
B3 3
B4 4
E1 A
E2 C
E3 E
E4 B
I need a formula that will:
If cell E1 is within range A:A then cell F1 should result B#
My results in F should be:
F1 1
F2 3
F3 "blank"
F4 2
Thanks
Catherine
A1 A
A2 B
A3 C
A4 D
B1 1
B2 2
B3 3
B4 4
E1 A
E2 C
E3 E
E4 B
I need a formula that will:
If cell E1 is within range A:A then cell F1 should result B#
My results in F should be:
F1 1
F2 3
F3 "blank"
F4 2
Thanks
Catherine