View Full Version : [SOLVED:] Help with formula
blackie42
10-20-2016, 05:00 AM
Hi
Trying to figure out how I get the following result (need formulae in columns B & C) from input in to Column A
ColA
ColB
ColC
A
A
B
B
A_B
A
B
Any help much appreciated
thanks
Jon
mancubus
10-20-2016, 05:32 AM
assuming Row 1 contains headers and actual values in Colum A are "A" or "B" or "A_B":
Formula in A2:
=IF(OR(A2="A",A2="A_B"),"A","")
Formula in B2:
=IF(OR(A2="B",A2="A_B"),"B","")
copied down.
mancubus
10-20-2016, 05:39 AM
OR
Formula in A2:
=IF(ISNUMBER(SEARCH("A",A2)),"A","")
Formula in B2:
=IF(ISNUMBER(SEARCH("B",A2)),"B","")
copied down.
or other methods...
mancubus
10-20-2016, 05:42 AM
for case-sensitive lookup, use FIND function rather than SEARCH function.
petroj02
10-20-2016, 06:06 AM
for cell B1
=if(or(A1="A";A1="A_B");"A";"")
for C1
=if(or(A1="B";A1="A_B");"B";"")
same for next rows but swap A1 to A2 or A3
blackie42
10-20-2016, 08:14 AM
Thanks guys,
The IF IS NUMBER formula seems to work best
regards
Jon
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.