+ Reply to Thread
Results 1 to 3 of 3

Identify Matches and return values

  1. #1
    Registered User
    Join Date
    10-28-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    5

    Question Identify Matches and return values

    Good morning all.

    I'm trying to write a formula that will:
    1) Check to see if a value in column A of worksheet A appears in column A on worksheet B.
    2) If it DOES, then display the value from the same row from column B on worksheet B, in column B on worksheet A.
    3) If it DOESN'T, display the value "EACH" in column B on worksheet A.

    e.g.

    WORKSHEET A
    __A___ ___B___
    111111 EACH
    222222 KG
    333333 EACH

    WORKSHEET B
    __A___ ___B___
    111123 KG
    999999 G
    222222 KG

    Any suggestions?

    Thanks in advance,

    C
    Last edited by charlierivers; 11-10-2009 at 05:07 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Identify Matches and return values

    Numerous options in truth but the standard approach would be:

    A!B1
    =IF(ISNA(MATCH($A1,'B'!$A:$A,0)),"EACH",VLOOKUP($A1,'B'!$A:$B,2,0))
    copied down

  3. #3
    Registered User
    Join Date
    10-28-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Identify Matches and return values

    Once again you have saved the day.

    Thank you!

+ 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