JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 582
- Office Version
- 365
- Platform
- Windows
I am having a brain block.
I have 4 columns with number and label. a1:a30 are numbers, b1:b30 are labels. C1:c30 are numbers, D1:D30 are labels All in random order.
I am trying to match the labels in column B to the label in Column D and then add the 2 numbers corresponding numbers in column A and C.
5 abc 5 cde
4 cde 4 xyz
so for the label CDE it would return a value of 9 or the sum of c1+a2
Thanks
James
I have 4 columns with number and label. a1:a30 are numbers, b1:b30 are labels. C1:c30 are numbers, D1:D30 are labels All in random order.
I am trying to match the labels in column B to the label in Column D and then add the 2 numbers corresponding numbers in column A and C.
5 abc 5 cde
4 cde 4 xyz
so for the label CDE it would return a value of 9 or the sum of c1+a2
Thanks
James