troubleshooting Question

Excel 2007 Comparing Cell Contents with IF Statements

Avatar of baleman2
baleman2 asked on
Microsoft OfficeMicrosoft Excel
12 Comments1 Solution87 ViewsLast Modified:
I have data in columns for which I need to make 3 different comparisons.

 I. Exact data comparison in a specific cell of Column C with all cell contents of Column G.
     A. If a "match" is found, I need to move cell contents from 2 different rows to another sheet: Sheet 2
        1) Cell C2 contains the data:  1S394A0
            a) I need to compare this "exact" data with all the cell contents in Column G
            b) An "exact" match is found in cell G22:  1S394A0
        2) Move A2, B2, C2, D2, F22, G22, H22 to the same row on Sheet 2
     B. For clarification, I have manually made these entries on Sheet 2

The following request may have to do with truncating leading digits/letters

II. Inexact data comparison in a specific cell of Column C with all cell contents in Column G.
     A. If a "match" is found of "inexact" data, I need to move cell contents from 2 different rows to another sheet: Sheet 2  
         1) Cell C9 contains the data:  S0001
              a) I need to compare the contents of this cell with all the cell contents in Column G
              b) An "inexact" match is found in cell G1:  1S0001
              c) The leading digit "1" is all that keeps this from being an "exact" match.
              d) As long as the 5 digit data in C9 matches any part of the 5 digit data in the cells of Column G,
                  I would consider that a "match"
          2) Move A9, B9, C9, D9, F1, G1, H1 to the same row on Sheet 2
     B. For clarification, I have manually made these entries on Sheet 2

III. Data comparison in a specific cell of Column C with all cell contents in Column G results in "no match"
      A. If "no match" is found of data, I need to move cell contents from 1 row to another sheet 2
          1) Cell C8 contains the data:  NRL
              a) I need to compare the contents of this cell with all the cell contents in Column G
              b) There is no exact ( I ) match and there is no inexact ( II ) match
          2) Move A8, B8, C8, D8 to the same row on sheet 2
              a) The resulting rows of data containing no matches need to be grouped together, if possible
      B. For clarification, I have manually made these entries on Sheet 2

I'm a novice with "IF" statements in Excel, but this is beyond my level of expertise.

I've just inherited this mess from my department head(s) and must clean up tens of thousands of similar entries as presented in this workbook.

Please help.  

C--Users-dan-Desktop-Code_Compariso.xlsx
ASKER CERTIFIED SOLUTION
Robert Berke
Consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 1 Answer and 12 Comments.
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>

Mike

Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 12 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004