Get instant live Excel expert help with MATCH Functions

I HAVE TWO COLUMNS OF NUMBERS AND WANT TO COMPARE THE FIRST TO SECOND COLUMN AND FOR THE FORMULA TO DISPLAY IN A THIRD COLUMN THE DIFFERENCE EG +2 OR -2 IF THE FIRST COLUMN IS 4 AND SECOND COLUMN IS 2 THEN SHOULD DISPLAY IN THIRD COLUMN +2

I am trying to compare two Excel files. If a cell in WB1, row H3, matches a cell in WB2, B1 - I want it to display the contents in the WB2 A1 cell. It will need to loop through all of the cells in both workbooks and display results accordingly. What is the easiest way to do this?

Need to update a formula and need help...Want to compare the master file from the first tab to the other tabs, and get the number they have in common

I need to compare 2 sheets to find the difference in quantity since the list of items is quite huge.

I need to be able to combine a spread sheet with data on for 2 different years spend (i.e 2016/17 & 2017/18), I want to keep the years data separate but compare each customers spend trends. So really I am looking to merge the list of customers and for the spend to follow these movements but to ensure that each years spend stays separate. I hope this makes some sense.

Hello there! I have a large number of data over 600,000 in sheet and there are around 7-8 such sheets. I want to find and highlight the duplicate phone number present in "column I" in all the sheets. Is it possible to compare all sheets and get the duplicate entries from them Regards

I need help editing the following formula. =IF(VLOOKUP(I16,Transactions!$D:$J,1,0)=I16,"FALSE","TRUE") The formula should compare Column I on the "Payments" sheet and Column D on the "Transactions" sheet and return the value from Column I if the value is NOT included on the Transactions sheet.

For sales purposes i need to be able to compare the qualities of one vehicle against another but being able to have them pop up next to each other so the customer can compare the better qualities of one to another

I have a list of names which I want to compare to a set of columns which has a header and then a list of names in each column. I need the return to be a concatenated list of the headings of the columns each name appears in.

Hi, I am using Conditional Formatting in Excel. I am trying to compare text in one excel column to text in another column, but the text in the one of the columns is included within other text. So, for example, a cell in column A includes the phrase: "I use Excel everyday" and a cell in column B includes the phrase "use Excel". I am trying to figure out whether the phrase "use Excel" in column B appears in column A, even though it is included within other text. My entire spreadsheet is like this. Column B is a fragment of text in Column A. If I click on Conditional Formatting, New Rule, Format Only Cells That Contain, Specific Text...