+ Reply to Thread
Results 1 to 2 of 2

POWER Query and Power Pivot Table !!

  1. #1
    Registered User
    Join Date
    06-07-2017
    Location
    KSA
    MS-Off Ver
    2016
    Posts
    48

    POWER Query and Power Pivot Table !!

    Hi Exceler,

    Hope this thread finds you well.


    I am Trying to do the following step by using Power Query or by POwer Pivot table until now I did not find the correct way.

    I have an excel file with two sheets.
    First sheet contain 4 column A,B,C,D. The result should in new column F.
    The second sheet contains three column A, B, C.

    The column F will look first to column D If column D Exist in sheet 2 use it as result.
    Other ways go and check Column A If lookup for A Exist in sheet 2 Column B take it as result
    Other ways go and check in column B If lookup for B Exist in sheet 2 Column B take it as result
    Other ways go and check in column C If vlookup for C Exist in sheet 2 Column B take it as result other way make result show as a blank cell


    See the attachment, it contains a small example of what I want.


    Hope you got what I mean.
    Attached Files Attached Files
    Last edited by AliGW; 08-06-2018 at 06:16 AM. Reason: Moved to pivots section.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,108

    Re: POWER Query and Power Pivot Table !!

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (note: this change is not optional )
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  2. Replies: 0
    Last Post: 04-05-2018, 01:16 AM
  3. Replies: 15
    Last Post: 03-29-2018, 11:29 AM
  4. error in power query & power pivot
    By Baldev Kumar in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 01-03-2018, 01:34 AM
  5. Replies: 3
    Last Post: 12-03-2017, 01:41 PM
  6. [SOLVED] Pivot table from power query
    By pccamara in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 05-17-2017, 10:09 AM

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