G
Guest
Below is a sample of the details I want to display
A B
1 CODE1 DISPLAY1
2 CODE2 DISPLAY2
3 CODE3 DISPLAY3
I want to display the corresponding value in column B in E7 (see below), if
one of the three cells E4:E6 displays that code.
E
4 BLANK CELL
5 CODE2
6 BLANK CELL
7 DISPLAY2
can this be done, and how would it be done??
A B
1 CODE1 DISPLAY1
2 CODE2 DISPLAY2
3 CODE3 DISPLAY3
I want to display the corresponding value in column B in E7 (see below), if
one of the three cells E4:E6 displays that code.
E
4 BLANK CELL
5 CODE2
6 BLANK CELL
7 DISPLAY2
can this be done, and how would it be done??