Hi,
I have two spreadsheets with the same columns names with similar data. i am try to find the difference between each sheet vs the other based on if a certain value is the same on each sheet in a another column.
See below my example sheets for reference to what i am trying to achieve and the "Formula that i need" to solve.
Sheet 1:
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
Any help is much appreciated, i am quite a novice with Excel formulate of this type so just looking for some guidance. By the way i have trying a few things to no avail.
I have two spreadsheets with the same columns names with similar data. i am try to find the difference between each sheet vs the other based on if a certain value is the same on each sheet in a another column.
See below my example sheets for reference to what i am trying to achieve and the "Formula that i need" to solve.
Sheet 1:
Column A | Column B | Formula that i need |
1 | TEXT1 | match TEXT in Column B in both Sheet 1 & 2 only if Column A value (1) is the same as Sheet 2 in Column A value (1) and provide answer of True, otherwise an answer of False |
2 | TEXT1 | |
3 | TEXT2 |
<tbody>
</tbody>
Sheet 2
Column A | Column B |
1 | TEXT2 |
1 | TEXT1 |
1 | TEXT3 |
<tbody>
</tbody>
Any help is much appreciated, i am quite a novice with Excel formulate of this type so just looking for some guidance. By the way i have trying a few things to no avail.