GJones7
03-25-2017, 11:11 AM
This is my first time on the site and hopefully someone can help!
I have specific text in column D that I want to look-up replace with text from column B if the value in column D is equal to column C, but within a range of rows sharing a the same cell reference in column A
The text to be replaced will always be within the symbol § and not fixed to 4 characters, they are part of equations so other text needs to be ignored.
Also if it couldn't find a match I would need this easily identifiable, i.e. replace the text with #N/A instead, so it can be investigated,
Before
A
B
C
D
E
1
Ref.1
10
AAAA
2
Ref.1
20
BBBB
3
Ref.1
30
CCCC
4
Ref.1
40
DDDD
(§CCCC§*§AAAA§*10)/(§BBBB§-§EEEE§)
5
Ref.1
50
EEEE
6
Ref.2
110
AAAA
7
Ref.2
120
BBBB
(§AAAA§ - §DDDD§) * 1000 * 0.5 /(10*5)
8
Ref.2
130
CCCC
9
Ref.2
140
DDDD
After
A
B
C
D
E
1
Ref.1
10
AAAA
2
Ref.1
20
BBBB
3
Ref.1
30
CCCC
4
Ref.1
40
DDDD
(30*10*10)/(20-#N/A)
5
Ref.1
50
EEEE
6
Ref.2
110
AAAA
7
Ref.2
120
BBBB
(110 - 140) * 1000 * 0.5 /(10*5)
8
Ref.2
130
CCCC
9
Ref.2
140
DDDD
I have specific text in column D that I want to look-up replace with text from column B if the value in column D is equal to column C, but within a range of rows sharing a the same cell reference in column A
The text to be replaced will always be within the symbol § and not fixed to 4 characters, they are part of equations so other text needs to be ignored.
Also if it couldn't find a match I would need this easily identifiable, i.e. replace the text with #N/A instead, so it can be investigated,
Before
A
B
C
D
E
1
Ref.1
10
AAAA
2
Ref.1
20
BBBB
3
Ref.1
30
CCCC
4
Ref.1
40
DDDD
(§CCCC§*§AAAA§*10)/(§BBBB§-§EEEE§)
5
Ref.1
50
EEEE
6
Ref.2
110
AAAA
7
Ref.2
120
BBBB
(§AAAA§ - §DDDD§) * 1000 * 0.5 /(10*5)
8
Ref.2
130
CCCC
9
Ref.2
140
DDDD
After
A
B
C
D
E
1
Ref.1
10
AAAA
2
Ref.1
20
BBBB
3
Ref.1
30
CCCC
4
Ref.1
40
DDDD
(30*10*10)/(20-#N/A)
5
Ref.1
50
EEEE
6
Ref.2
110
AAAA
7
Ref.2
120
BBBB
(110 - 140) * 1000 * 0.5 /(10*5)
8
Ref.2
130
CCCC
9
Ref.2
140
DDDD