LookUp and Concatentate
 

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.

=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.