computing
  • 0

Solved Searching for multiple numbers within a data set

  • 0

In Excel, I have 2 sheets of data. One sheet contains a list of numbers (about 500 line items) . The other sheet (sheet 2) is imported and it conatins about (150 lines). I need excel to search sheet 1 with the numbers I have in sheet 2 and tell me if there are any matching numbers.

Anyone able to help?

Share

0 Answers

  1. Try this:

    With your data in Sheet 1 in Column A starting at cell 1 to cell 500
    and
    With your data in Sheet 2 in Column A starting at cell 1 to cell 150

    On Sheet 2 enter the formula cell B1:

    =IF(ISERROR(MATCH(A1,Sheet1!$A$1:$A$500,0)),”No Match in Sheet 1″,”Match”)

    Drag down 150 rows.

    If there is a Match, then the word Match will appear in column B
    If there is no Match, then No Match in Sheet 1 will appear in column B

    Also, since your importing the data, make sure your Numbers are really Numbers not TEXT that look like numbers.

    Real numbers will be Right Justified in the cell.

    A simply way to insure all your numbers are numbers is to do a simple: =A1*1 this should force any TEXT to Numbers.

    See how that work.

    Also, Excel questions are best asked in the Office Software Forum.

    MIKE

    http://www.skeptic.com/

    • 0