Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |