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. |
#2
|
|||
|
|||
=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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|