+ Reply to Thread
Results 1 to 3 of 3

Comparing 2 sheets in Excel and returning a value if there is a match

  1. #1
    Registered User
    Join Date
    02-18-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    3

    Comparing 2 sheets in Excel and returning a value if there is a match

    Hi

    Only new to this forum im not very good at Excel however i need help ASAP for work.

    I have a workbook with 2 sheets.
    Sheet 1 has references in J2-J10892 which i need to compare with Sheet 2 C7-C1531 and if any of these cells match up i need to return the value that is in sheet 1 k2-k10892
    I have my forumula in sheet 2 cell I7

    Hope that makes sense!

    Thanks

    Ava
    Last edited by ava285; 02-20-2013 at 09:44 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Comparing 2 sheets in Excel and returning a value if there is a match

    Okay, put this formula in I7 on Sheet2:

    =IF(COUNTIF(Sheet1!J:J,C7)>0,VLOOKUP(C7,Sheet1!J:K,2,0),"")

    then copy it down to row 1531.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    02-18-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Comparing 2 sheets in Excel and returning a value if there is a match

    Hi Pete
    This is exactly what i was after, thankyou very much!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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