How can I extract data from one excel file which matches with another excel file’s data?

Posted by:

How can I extract data from one excel file which matches with another excel file’s data?

How can I extract data from one excel file which matches with another excel file’s data? This goes back to the concept of cell and workbook referencing.

What you need to do is open both files and write a simple if() formula, testing if they are equal and returning a value or string if they are or not.

In 1991, Adobe cofounder Dr. John Warnock launched the paper-to-digital revolution with an idea he called The Camelot Project. The goal was to enable anyone to capture documents from any application, send electronic versions of these documents anywhere, and view and print them on any machine. By 1992, Camelot had developed into PDF. Today, it is the format trusted by businesses around the world.

For example if you want to see if two Excel workbooks have the same string “This,” all you need to do is have enter the formula into the cell you want to show the result:

How can I extract data from one excel file which matches with another excel file's data

=if(A1=’[Workbook_in_question.xlsx]Sheet_in_question’A1, DO THIS IF TRUE, DO THAT IF FALSE)

In this case I just cell referenced A1 from both workbooks, but it can be any cell(s) you wish.

0

Add a Comment