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.
In D2 Cell
Formula:
Please Login or Register to view this content.
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
SIXTHSENSE - you are awesome!! You just saved me countless hours trying to figure out such an equation. You rock! Thanks a million!!!
Rep+
Glad it helps you and thanks for the feedback and rep
I need something very similar to this but I need to easily see all the ones that don't match in one column.
If B1 does not equal A1 then output A1 to C1
Then I'll have a column that I can just copy and paste with a list of the ones that don't match.
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks