CODEWITHSUNDEEP
excelif-statement
shasons Udyog
shasons Udyog

Reputation: 1

if two cell values match the formula should return data from third cell as my answer

I manage accounts of my company and have many debit credit entries which are entered into various columns categorically

I am using if else conditions and whenever the data that needs to be shifted is numerical it works but when shifting data after comparing numerical values the formula results in inconsistent formula 

A          B          C           D         E
12         12       CASH SALE    CASH SALE   12

THIS IS WHAT I WANT THAT IF COLUMN A=B THEN DATA OF COLUMN A SHOULD GO TO E AND NOTES MADE IN C SHOULD MOVE TO D.

Upvotes: 0

Views: 75

Answers (1)

vogomatix
vogomatix

Reputation: 5071

Define your formula in the target cells i.e. cells in columns D and E 

Column D                   Column E
=IF(A1=B1, C1, "")         =IF(A1=B1, A1, "")

Upvotes: 1

Related Questions