Results 1 to 3 of 3

Identify Matches and return values

Threaded View

  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.

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