+ Reply to Thread
Results 1 to 2 of 2

Lookup only non zero items

Hybrid View

  1. 09-25-2020, 11:58 AM #1
    Sybon
    Sybon is offline
    Registered User
    Join Date
    08-23-2020
    Location
    Dhaka
    MS-Off Ver
    2016
    Posts
    23

    Lookup only non zero items

    Hi Experts!!
    Could you please help me at the attached file. I want to pull data Final-1 to Final list. Only non zero value as well the shops and items.
    Attached Files Attached Files
    Last edited by Sybon; 09-25-2020 at 12:16 PM.
    Reply With QuoteRegister To Reply
  2. 09-25-2020, 01:10 PM #2
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Lookup only non zero items

    Hi.

    Are you trying to Use Power Query to do this?
    Attached Files Attached Files
    Last edited by mehmetcik; 09-25-2020 at 10:04 PM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.
    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. [SOLVED] Lookup multiple items
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-15-2016, 08:27 AM
  2. Lookup and count items
    By Losman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2016, 01:08 PM
  3. [SOLVED] lookup 2 items and return value of both
    By interested in forum Excel General
    Replies: 4
    Last Post: 08-14-2013, 04:44 AM
  4. Multiple Lookup Items
    By choke in forum Excel General
    Replies: 1
    Last Post: 06-18-2012, 01:29 PM
  5. Lookup up items on another sheet.
    By Keytonic in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-23-2009, 02:54 PM
  6. How to add multiple items using lookup?
    By Weasel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-13-2008, 06:34 PM
  7. [SOLVED] Sum items in a lookup table.
    By JICDB in forum Excel General
    Replies: 2
    Last Post: 12-30-2005, 10:13 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1