+ Reply to Thread
Results 1 to 6 of 6

Compare Data in 2 Sheets with Either V LookUP OR Index Match

  1. #1
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    143

    Compare Data in 2 Sheets with Either V LookUP OR Index Match

    Hi,

    In the enclosed file, I have two sheets namely, Previous and Current. From the Current Sheet I need to compare with Old One based on ID and Return Match / Not Match in columns Q, R, S.
    Comparison is only for Gross, Bank Account and IFSC,

    Can you please help me in writing a formula, it would be of great help
    Last edited by FlameRetired; 06-01-2020 at 04:32 PM.

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Botswana
    MS-Off Ver
    Professional Plus 2019
    Posts
    836

    Re: Compare Data in 2 Sheets with Either V LookUP OR Index Match

    I hope your data is fake. If not, please remove.
    Pete

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    12,163

    Re: Compare Data in 2 Sheets with Either V LookUP OR Index Match

    I have to agree with Pete.

    That data looked very real. I removed the file. Please upload another example with desensitized data.
    Dave

  4. #4
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Botswana
    MS-Off Ver
    Professional Plus 2019
    Posts
    836

    Re: Compare Data in 2 Sheets with Either V LookUP OR Index Match

    Dave. Thank you. Not for nuthin, but it would help that if in this forum there was a link or a button to contact an online admin immediately. Sure, possible misuse, and an expectation of immediacy that may not be realized, and resultant fallout. Not ideal, but does provide an answer to "what can I do"?

    Dave, I remember a few years ago, I tried to alert an admin concerning a post. I heard from someone 4-5 days later, asking if I still needed help. Thanks again.

    Pete

  5. #5
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    143

    Re: Compare Data in 2 Sheets with Either V LookUP OR Index Match

    I resolved the problem myself. Thank You

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    12,163

    Re: Compare Data in 2 Sheets with Either V LookUP OR Index Match

    Quote Originally Posted by PeteABC123 View Post
    Dave. Thank you. Not for nuthin, but it would help that if in this forum there was a link or a button to contact an online admin immediately. ....

    Pete
    You are welcome. I ran into the same issue a few years back (pre-Mod days). I used the 'Report Post' button in the lower left and stated my concerns in the reply window. I seem to recall action by late that evening. It also keeps the issue under the 'radar' so as to reduce risk of sensitive data exposure pending resolution. Still not ideal but more likely to be seen by Mods/Admin (the only ones who can take decisive action) in a more timely way.

    You could post your thoughts in the ideas for improvement thread. I wouldn't hold your breath though. Admin and Moderators far more senior than me indicate that management/owners show little interest in improving the site.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 10-16-2019, 09:58 PM
  2. [SOLVED] Compare two sheets...index match formula issue?
    By gimlay in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-02-2019, 07:27 PM
  3. How to compare data using index match with two condition
    By devawad in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-23-2018, 02:50 PM
  4. [SOLVED] INDEX / MATCH Lookup across 2 sheets
    By LauraShepherd-Boyd in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-26-2017, 11:01 PM
  5. [SOLVED] Need help using LOOKUP (or INDEX-MATCH) between sheets
    By frankunited in forum Excel General
    Replies: 5
    Last Post: 02-12-2015, 01:29 PM
  6. [SOLVED] INDEX/MATCH Lookup based on Data from two additional sheets
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-08-2015, 02:07 PM
  7. Compare data with Index & Match function
    By herukuncahyono in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-27-2010, 02:17 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1