Hi everyone, I'm new here but I've got lots of solutions from this forum before. Now I'm here with a request for your help.
I have two data sheets in excel with info as below.
Sheet 1
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
What I would like to do is, if the Value in Sheet 2 Column 1 matches the value in Sheet 1 and if the value in sheet 1 column 7 (ending balance) is greater than 0, I want it to bring out "Yes" in Sheet 1 Column 6 (Active?)
I have two data sheets in excel with info as below.
Sheet 1
Account | Description | Cost Center | Beginning Balance | Debit | Credit | Ending Balance |
1000000 | Furniture | XX02 | 2,000 | 1,500 | 300 | 3,200 |
2000000 | Cash | XX04 | 10,000 | 12,000 | 5,600 | 16,400 |
<tbody>
</tbody>
Sheet 2
Account | Description | Category 1 | Category 2 | Category 3 | Active? |
1000000 | Furniture | Balance Sheet | Non-Cur Asset | Property & Equipment | |
2000000 | Cash | Balance Sheet | Current Asset | Cash & Bank Balances |
<tbody>
</tbody>
What I would like to do is, if the Value in Sheet 2 Column 1 matches the value in Sheet 1 and if the value in sheet 1 column 7 (ending balance) is greater than 0, I want it to bring out "Yes" in Sheet 1 Column 6 (Active?)