+ Reply to Thread
Results 1 to 3 of 3

Datalookup on multiple results

Hybrid View

  1. #1
    Registered User
    Join Date
    06-24-2013
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    2

    Datalookup on multiple results

    Hi guys,

    Hoping you can help me with this.....

    I have a data table that contains a number of items SKU's (see capture.png)
    Capture.PNG

    What I need to do is to lookup a style code (partial match) against the list of SKU's and return all the results as shown here: Capture2.PNG

    Ideally it would insert a new row for each SKU allowing me to list all the Style codes in a single list and then run a function. I have no idea where to start with this (was thinking about adding it to a db and manipulating using PHP which would be easier for me :P so any help is appreciated)

    Thanks!

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Datalookup on multiple results

    Hi and welcome to the forum....would it be possible to upload a file with company info removed?....It's nice to get a lay of the land, so to speak.
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Registered User
    Join Date
    06-24-2013
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Datalookup on multiple results

    sure please see attached.example.xlsx

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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