Forum Discussion
Excel Formula: Look up column A, and if in Reference List, then fill column B accordingly
That could be like
with formula
=LOOKUP(LEFT(A1,SEARCH(".",A1)-1),$D$1:$D$6,$E$1:$E$6)
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!
You may wrap formula with IFERROR
=IFERROR(LOOKUP(LEFT(A10,SEARCH(".",A10)-1),$D$1:$D$6,$E$1:$E$6),"UNDETERMINED")Please check in attached file.
Hello,
I wish to reverse the formula, to generate column A Roman Numbers.
How you can help?
Thanks.
Robert.
REFERENCE LIST
I = LAISSE
II = STROPHIQUES
III = EN FORME DE DIALOGUE
IV = ÉNUMÉRATIVES
V = BRÈVES
VI = TIMBRES
A
B
C
II
II.C-36.1
STROPHIQUES
II
II.H-35.1
STROPHIQUES
II
II.C-24.1
STROPHIQUES
II
II.E-33.1
STROPHIQUES
II
II.C-9.1
STROPHIQUES
II
II.H-2.4
STROPHIQUES
UNDETERMINED
UNDETERMINED
UNDETERMINED
II
II.P-26.2
STROPHIQUES
III
III.H-15.1A
EN FORME DE DIALOGUE