Results 1 to 4 of 4

Thread: Look up in three columns

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 10-28-2016, 04:10 AM #1
    YasserKhalil
    YasserKhalil is offline
    VBAX Expert
    Joined
    May 2010
    Posts
    661

    Look up in three columns

    Hello everyone
    I need to lookup part of string in three columns and retrieve data related to it
    I have attached sample workbook ..
    In sheets("Main") I need to search for SKU in column C for example : "FNYD024-05XL" >> search for the first part only which is "FNYD024" ..
    This is in row 110 in sheets("Table") ... The search would be in three columns B & C & D in sheets("Table")
    If found take the values in both columns E & F

    If possible I need to do the task using VBA arrays
    Thanks advanced for help
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules