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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Formula that i need[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]TEXT1[/TD]
[TD]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[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]TEXT1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]TEXT2[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2
[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]TEXT2[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]TEXT1[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]TEXT3[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Formula that i need[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]TEXT1[/TD]
[TD]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[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]TEXT1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]TEXT2[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2
[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]TEXT2[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]TEXT1[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]TEXT3[/TD]
[/TR]
</tbody>[/TABLE]
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.