LookUp and Concatentate

[carl]

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.

 

[Bill Kuunders]

=IF(A2="A",C2&D2,"")

not sure about "find a match in colB of the data,"