Vlookup in VBA and adding text RRS feed

  • Question

  • I have tow different sheets in my work book. Sheet 1 and Sheet 2. I need to do vlookup between these two sheets (A column in both sheets) and if sheet 1 contains any element from Sheet 2, the the text "UG" should be updated in sheet 1 in "AE4" cell.

    Is it possible in VBA?

    Monday, January 9, 2017 12:01 PM

All replies

  • You could use a dictionary to do it.

    I looked your data the other day.  Have you considered using a database to store your data.  It makes it much easier to maintain and manipulate.  You do have the overhead of learning SQL.

    Monday, January 9, 2017 1:24 PM
  • Dictionary? 

    I just to to add an entry with text "UG" to the corresponding entries where the vlookup result is found.

    Monday, January 9, 2017 1:29 PM
  • Any help?
    Tuesday, January 10, 2017 12:43 AM