Results 1 to 6 of 6

Comparing two cells for similarities and output a third cell (if C1 = B1, then output A1)

Threaded View

  1. #1
    Registered User
    Join Date
    06-23-2013
    Location
    kansas
    MS-Off Ver
    Excel 2007
    Posts
    2

    Comparing two cells for similarities and output a third cell (if C1 = B1, then output A1)

    Hello ExcelForum!

    I've got (what I hope) is a simple formula that I need to develop. I'm trying to compare individual cells in two columns. If any cell in column C is equal to any cell in column B, then I'd like it to return the value of Column A (the value directly next to Column B). I am trying to hold the relationship that the value of A1 is tied to the value of B1 (and A2 is tied to B2, etc).

    I've attached a small sample that hopefully helps.
    Attached Files Attached Files

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