Forum Discussion
Excel Formula: Look up column A, and if in Reference List, then fill column B accordingly
Hello,
I need an Excel formula that look for roman number (see Reference List below), and if in this list, then fill column B. Can you help?
Thanks.
REFERENCE LIST
I = LAISSE
II = STROPHIQUES
III = EN FORME DE DIALOGUE
IV = ÉNUMÉRATIVES
V = BRÈVES
VI = TIMBRES
A | B |
II.C-36.1 | STROPHIQUES |
II.H-35.1 | STROPHIQUES |
II.C-24.1 | STROPHIQUES |
II.E-33.1 | STROPHIQUES |
II.C-9.1 | STROPHIQUES |
II.H-2.4 | STROPHIQUES |
I.O-3.6 | LAISSE |
II.P-26.2 | STROPHIQUES |
III.H-15.1A | EN FORME DE DIALOGUE |
That could be like
with formula
=LOOKUP(LEFT(A1,SEARCH(".",A1)-1),$D$1:$D$6,$E$1:$E$6)
8 Replies
That could be like
with formula
=LOOKUP(LEFT(A1,SEARCH(".",A1)-1),$D$1:$D$6,$E$1:$E$6)Marvellous, it works, thanks.
Another particularity in my column A, I've got some cells that yet to be determined.
A
B
II.C-36.1
STROPHIQUES
II.H-35.1
STROPHIQUES
II.C-24.1
STROPHIQUES
II.E-33.1
STROPHIQUES
II.C-9.1
STROPHIQUES
II.H-2.4
STROPHIQUES
UNDETERMINED
UNDETERMINED
II.P-26.2
STROPHIQUES
III.H-15.1A
EN FORME DE DIALOGUE
I apologize, I should had mentioned. How can I modify?
Robert.
- With UNDETERMINED, I get this: #VALUE!
