Data Compare and result as true or false in result sheet

		Microsoft Office Forums > Microsoft Excel > Excel
Data Compare and result as true or false in result sheet

FAQ

Thread Tools

Display Modes

08-29-2019, 05:40 AM

aligahk06

Windows XP Data Compare and result as true or false in result sheet

Office 2007

Advanced Beginner

Join Date: Aug 2009

Posts: 58

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

TestFileData.xlsx (309.8 KB, 7 views)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
One Cell that controlls spread sheet result button to change simple fomula result	RAH	Excel Programming	5	03-31-2018 04:52 PM
Converting a 1 or 0 into TRUE or FALSE?	ayupchap	Mail Merge	1	04-25-2017 02:45 PM
How To Move Focus From VLOOKUP Result to Report Sheet	swindon.expat	Excel	2	04-10-2016 12:15 AM
Mail merge result in separate world files instead of one file containing all the data	xdhbsh	Mail Merge	3	12-24-2015 12:23 AM
Lookup multiple values and compare different scenarios to get a specific result	mws	Excel	5	05-24-2014 04:52 AM