+ Reply to Thread
Results 1 to 6 of 6

Search for a specific product and return an array of the product details

  1. 09-02-2022, 12:02 PM #1
    Richmond88
    Richmond88 is offline
    Registered User
    Join Date
    07-25-2022
    Location
    Singapore
    MS-Off Ver
    Office 365
    Posts
    18

    Search for a specific product and return an array of the product details

    I have attached a worksheet.

    What I need is to be able to Search for a certain product (highlighted in yellow)
    And return multiple values (highlighted in orange) according to the data provided (highlighted in blue)

    Any help is appreciated
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-02-2022, 12:33 PM #2
    torachan
    torachan is offline
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,411

    Re: Search for a specific product and return an array of the product details

    what is wrong in just using the inbuilt data filter ????
    Attached Files Attached Files
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
    Reply With QuoteRegister To Reply
  3. 09-02-2022, 12:45 PM #3
    Richmond88
    Richmond88 is offline
    Registered User
    Join Date
    07-25-2022
    Location
    Singapore
    MS-Off Ver
    Office 365
    Posts
    18

    Re: Search for a specific product and return an array of the product details

    Quote Originally Posted by torachan View Post
    what is wrong in just using the inbuilt data filter ????
    I want to see only the data of the searched product.
    Reply With QuoteRegister To Reply
  4. 09-02-2022, 12:48 PM #4
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Search for a specific product and return an array of the product details

    you can try Power Query as follows


    Product List(tora(v1)).xlsx
    Attached Files Attached Files
    Last edited by sandy666; 09-02-2022 at 01:41 PM.
    Reply With QuoteRegister To Reply
  5. 09-02-2022, 12:53 PM #5
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,790

    Re: Search for a specific product and return an array of the product details

    With a formula in A23 only
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 09-02-2022, 01:39 PM #6
    Czeslaw
    Czeslaw is offline
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,418

    Re: Search for a specific product and return an array of the product details

    Power Query
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA to create a dynamic array which sums sales to a specific client based on product
    By SrAlx in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-07-2019, 05:43 PM
  2. [SOLVED] Reverse of sumproduct : product of product of array?
    By rinkjames in forum Excel General
    Replies: 6
    Last Post: 11-20-2019, 04:23 PM
  3. [SOLVED] Search for a specific product number within a xls sheet
    By bilglassrolf in forum Excel General
    Replies: 10
    Last Post: 02-04-2019, 09:56 AM
  4. Macro to lookup and return lowest product price from specific website
    By timmy1254 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-13-2014, 12:02 AM
  5. [SOLVED] Rolling 12 month return by portfolio using product(if()) array
    By spcw in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-21-2014, 04:47 PM
  6. [SOLVED] Find Product Details in Another Sheet based on Product ID and Copy some Fields From there
    By kevalkothari in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-29-2012, 10:43 AM
  7. Sum Product question, or any other function to search, match and return sum.
    By Ali79 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-25-2012, 04:56 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1