+ Reply to Thread
Results 1 to 2 of 2

IF statement and VLOOKUP functionality in Power Query

  1. 02-22-2021, 02:59 AM #1
    zz_zz11
    zz_zz11 is offline
    Registered User
    Join Date
    08-01-2020
    Location
    US
    MS-Off Ver
    MS 365
    Posts
    28

    IF statement and VLOOKUP functionality in Power Query

    Hi,

    I am using Power Query and I need to vlookup a value from another table when certain criteria (e.g. Month of the year) is the same. Please see the file attached. Any help would be appreciated!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-22-2021, 07:41 AM #2
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,997

    Re: IF statement and VLOOKUP functionality in Power Query

    Use a query for each table and merge them on the Month field.
    Everyone who confuses correlation and causation ends up dead.
    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] If-Or statement Formula for Power Query
    By Eric Tsang in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-12-2021, 08:12 AM
  2. Power query, vlookup and formula
    By sunboy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-07-2020, 10:11 AM
  3. If - And Statement in Power Query
    By brent_milne in forum Excel General
    Replies: 1
    Last Post: 09-17-2020, 02:27 PM
  4. [SOLVED] How to add an Excel formula code into Power Query or create a new one in Power Query
    By afgi in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  5. [SOLVED] Power Query - One works the other does not (replace with if statement) - Why?
    By learning new things in forum Excel General
    Replies: 13
    Last Post: 08-20-2018, 09:46 PM
  6. 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
  7. Replicating COUNTIFS functionality in Power Query
    By 4am in forum Excel General
    Replies: 2
    Last Post: 04-03-2018, 08:47 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