+ Reply to Thread
Results 1 to 2 of 2

compare 2 columns if same lookup 3rd column and enter that data

  1. #1
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2010
    Posts
    745

    compare 2 columns if same lookup 3rd column and enter that data

    hi
    i am a bit confused as to which way and how to this the best,i have a userform and textboxes and listbox,these add,update,delete and clear,all works perfectly well,i would like to know the best way to get around my problem,enter a new record using last name,search button is for updating ect,enter say d308,fill in textboxes with anything,the last one add hyperlink you can put anything in as macro1 turns this into a hyperlink,click add button,all writes to sheet,column( i )gets same number as column (a) if you enter text in add hyperlink,what i like to do is if there is not a hyperlink address in column(h),to look up column (a)look at its number and if theres a hyperlink in(h)to add this to all entries of same number,i put the number in (i) to compare if (a) matches (i ) then lookup(h)and add these
    to all matching rows,have spent all day looking and trying different codes, but totally stumped ,i would need the code for add button, and update, as hyperlinks s could be entered anytime,im open to suggestions if any has some please
    cheers colin
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2010
    Posts
    745

    Re: compare 2 columns if same lookup 3rd column and enter that data

    hi
    any one with any ideas please ,best route to take
    cheers colin

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 14
    Last Post: 05-21-2012, 01:53 PM
  2. Replies: 3
    Last Post: 03-30-2012, 07:21 AM
  3. Compare 2 columns in 2 sheets then enter data from a 3rd cell? Help!
    By julietayl in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-28-2012, 09:18 AM
  4. How to compare two columns and enter 3rd value if matched
    By Archimedes in forum Excel General
    Replies: 4
    Last Post: 12-20-2009, 05:05 PM
  5. Compare 2 columns and choose one and enter answer in third column
    By Betsy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2006, 01:20 PM

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