How to compare two cells in excel sheet

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-


I AM HAVING TWO EXCEL SHEETS HAVING DATA.THE FIRSTTHE EXCEL SHEETS COLUMN A AND SECOND EXCEL SHEETS COLUMN B CONTAINS TRANSACTION REFERENCE IN A STRING WITH ALPHA NUMERICAL CHARACTERS.I WANT TO DISPLAY THE TRANSACTION REFERENCE BY THE COLUMN IN THE FIRST WORK SHEET IF THE STRING CHARACTER MATCHES.FURTHER I WANT TO DISPLAY THE CONTENTS OF COLUMN D AND C OF THE SECOND WORK SHEET BESIDES THE MATCHEH RECORDS'

plesae help me in solving this problem
M.P.SAMPATH
email:sampath_kanthi@hotmail.com

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample file on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.