=IF(A2="A",C2&D2,"")
not sure about "find a match in colB of the data,"
--
Greetings from New Zealand
Bill K
So in column B next to the 123 cell you would enter =IF(A2=A,
"carl" wrote in message
...
My data looks as so:
Data ColA ColB ColC ColD
A 123 Zebra Monkey
B 456 Dog Cat
C 123 Mouse Rabbit
A 789 Horse Cow
C 789 Cat Dog
I'm trying to put a formula into ColB of the table below that will look in
ColA and find a match in ColB of the data, and if ColA of the data is
equal
"A", concatenate the values in ColC and ColD - as shown below.
Table
123 ZebraMonkey
456
789 HorseCow
Thank you in advance.
|