GirishDhruva
Active Member
- Joined
- Mar 26, 2019
- Messages
- 308
Hi everyone,
I had created same thread https://www.mrexcel.com/forum/excel-questions/1098491-if-values-column-d-matches-then.html but as i couldn't view that thread i have created this.
Here i am trying to check the values in column 'D' and if the values in column 'D' matches then in column B it should print the value '60' else it should print '10'.
Like
<tbody>
</tbody>
The values in column 'D' can also be text
Thanks in advance
I had created same thread https://www.mrexcel.com/forum/excel-questions/1098491-if-values-column-d-matches-then.html but as i couldn't view that thread i have created this.
Here i am trying to check the values in column 'D' and if the values in column 'D' matches then in column B it should print the value '60' else it should print '10'.
Like
Column A | Column B | Column D |
1 | 60 | 4359 |
2 | 10 | 45132 |
3 | 10 | '4324 |
4 | 10 | 1324 |
5 | 10 | 5123 |
6 | 60 | '4359 |
7 | 10 | 06471 |
8 | 10 | 12345 |
9 | 60 | '4359 |
10 | 10 | 53121 |
11 | 60 | 4359 |
12 | 10 | '5123 |
13 | 10 | 512323 |
14 | 60 | 4359 |
<tbody>
</tbody>
The values in column 'D' can also be text
Thanks in advance