Hello,
I have a 2-worksheet book. In the first sheet is something like the following:
column 1 column 2
A red
B blue
C green
D yellow
In the 2nd sheet I have column 1 with some details - I would insert the letter corresponding to the color in column 2 and would like the name of the color to appear in column 3.
column 1 column 2 column 3
roof D ??
door C ??
window D ??
floor B ??
What formula needs to be entered in column 3? Thanks very much!
I have a 2-worksheet book. In the first sheet is something like the following:
column 1 column 2
A red
B blue
C green
D yellow
In the 2nd sheet I have column 1 with some details - I would insert the letter corresponding to the color in column 2 and would like the name of the color to appear in column 3.
column 1 column 2 column 3
roof D ??
door C ??
window D ??
floor B ??
What formula needs to be entered in column 3? Thanks very much!