+ Reply to Thread
Results 1 to 4 of 4

Compare an alphanumeric cell with column and copy data from the matched adjacent value

  1. #1
    Registered User
    Join Date
    10-30-2012
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Post Compare an alphanumeric cell with column and copy data from the matched adjacent value

    Hello Friends,

    I want to compare and find text in column B with text in column E, and when the match is TRUE copy the adjacent cell date&time details into another cell.
    Here is my question as below,

    Column B Column C Column D Column E Column F
    ABZDS000 Date & Time Copy Date and Time matched cell ABZDS000 ate & Time

    as per above example, Column D will be copied with date and time values from column F when the column B and E matches. This I want to achieve if the date and time is really matches with values in Column C as this is the newly available values and column E and F values are old values.

    Hope I did not made it too....confusing...!!

    Thanks for your help!

  2. #2
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Compare an alphanumeric cell with column and copy data from the matched adjacent value

    Quote Originally Posted by fondofexcel View Post
    as per above example, Column D will be copied with date and time values from column F when the column B and E matches.
    I follow you as far as there. You then, to use your own word, make it "confusing"

    This should be very straightforward to arrange. Will you post a small sample workbook (one row of information is fine) showing exactly what you want to achieve, (you can just type in the values as they should be) and we should be able to get you started.
    Brendan.


    __________________________________________________________________________________________________
    Things to consider:

    1) You can thank any poster by clicking the * at the left of a helpful post.
    2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
    3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.

  3. #3
    Registered User
    Join Date
    10-30-2012
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Compare an alphanumeric cell with column and copy data from the matched adjacent value

    compare&copy.JPG

    Please find the attachment I have copied that exactgly how I am looking to achieve the results. Thanks again.

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Compare an alphanumeric cell with column and copy data from the matched adjacent value

    Quote Originally Posted by fondofexcel View Post
    Please find the attachment I have copied that exactgly how I am looking to achieve the results. Thanks again.
    In D5 cell
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Drag it down

    To Hide Error
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    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

+ 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