View Single Post
 
Old 08-29-2019, 05:40 AM
aligahk06 aligahk06 is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: Aug 2009
Posts: 58
aligahk06 is on a distinguished road
Default Data Compare and result as true or false in result sheet

Dear All,
I have a sheet Mdata and Bdata and third sheet is result sheet.
I want to cross check data in Mdata sheet and data in Bdata sheet and result in result sheet as true or false in B4 and so on.
for ex. Mdata sheet value i.e A4, B3, B4 MATCH WITH BDATA SHEET THEN MATCH TRUE OR FALSE VALUE IN IN RESULT SHEET B4 AND SO ON.

Please find the attached sheet for ref.
Attached Files
File Type: xlsx TestFileData.xlsx (309.8 KB, 5 views)
Reply With Quote