+ Reply to Thread
Results 1 to 4 of 4

Compare Identical Text in two cells on two sheets-return value on target row into cell

  1. #1
    Registered User
    Join Date
    12-29-2012
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    43

    Compare Identical Text in two cells on two sheets-return value on target row into cell

    I have a workbook with tons of programming I need to achieve. I am very limited in my knowledge. I searched for this idea and it either isn't here or I don't know how to apply what I have found. So here is my work book so it can be viewed.

    Right now on "Protocol" Sheet I want the cells with the "Protocol 1" field to look at Admin_Panel Sheet and find the row with the same text. Then take the text in cell A of the same row and copy it to the cell below the "Protocol 1" listed on the protocol sheet.


    I have tried several codes from the forum and tried vLOOKup but again I don't know the syntax that well to fumble my way through this. Someof my data use drop down boxes to populate the fields.
    Attached Files Attached Files

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Compare Identical Text in two cells on two sheets-return value on target row into cell

    Does this work for you

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  3. #3
    Registered User
    Join Date
    12-29-2012
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    43

    Re: Compare Identical Text in two cells on two sheets-return value on target row into cell

    It pulls the data fine. The only issue now is I have a sort button to list rows in alphabetical order. So this code is always targeting the static cell. I need it to move with the cells even when sorted

  4. #4
    Registered User
    Join Date
    12-29-2012
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    43

    Re: Compare Identical Text in two cells on two sheets-return value on target row into cell

    Actually...this is correct. I had a code that was causing two of my cells for look up to be labled Protocol 1. So the first one in the list after sort is what was showing up else where. 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