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)
Not sure I understood correctly, but if values into column Has from B, when like
=LEFT(B1,SEARCH(".",B1)-1)
Hello,
I wish to apply an Excel formula in Column B, that looks in Column A, and refers to Column D and E (Reference List), then AutoFills with Roman numerals as shown. Can you help?
Again, I’ve got some cells in Column A that are Undetermined. I've modify one your suggested formulas, but it doesn't work.
Thanks for your patience,
Robert Richard
A | B | C | D | E |
STROPHIQUES | II |
| I | LAISSE |
STROPHIQUES | II |
| II | STROPHIQUES |
STROPHIQUES | II |
| III | EN FORME DE DIALOGUE |
STROPHIQUES | II |
| IV | ÉNUMÉRATIVES |
STROPHIQUES | II |
| V | BRÈVES |
STROPHIQUES | II |
| VI | TIMBRES |
UNDETERMINED | UNDETERMINED |
|
|
|
STROPHIQUES | II |
|
|
|
EN FORME DE DIALOGUE | III |
|
|
|
Robert, formula in column B could be
=IFNA(INDEX([LÉGENDES POUR FORMULES EXCEL],MATCH([@[CÔTES AU CATALOGUE]],[LÉGENDES POUR FORMULES EXCEL2],0)),"UNDETERMINED")If you open attached file it will be converted into your locale automatically (if it's not English).