Forum Discussion
Solved
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 = STROP...
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.
