Closed Thread
Results 1 to 3 of 3

IF(Match),(vlook) is creating SPILL

  1. #1
    Registered User
    Join Date
    06-01-2022
    Location
    United States
    MS-Off Ver
    2021
    Posts
    5

    IF(Match),(vlook) is creating SPILL

    Hi Everyone.

    I wrote a Query that pulls a custom table from my SQL. It pulls product num, month, year, and sales total for each month. Here is a look at the table for one product:

    table1.png



    I am trying to put that table in to excel so we can have live forecasting for each product. I have it organized by month over 2.5 years.

    table2.png


    My formula is
    "=IF(MATCH(9,sales_20[[MONTH(datescheduledfulfillment)]:[MONTH(datescheduledfulfillment)]],0),LOOKUP($A8,sales_20[[productnum]:[productnum]],sales_20[[count(soitem.qtyOrdered)]:[count(soitem.qtyOrdered)]]),0)"

    This formula only returns the value of the product within month 11. Does anyone have a better solution to looking up a value with a constraint in another column?

    Thanks!

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: IF(Match),(vlook) is creating SPILL

    Please note instructions for workbook upload at top of the page.
    Dave

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,398

    Re: IF(Match),(vlook) is creating SPILL

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...nstraints.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 01-27-2021, 12:07 PM
  2. Spill Error with index match formula
    By Daniel_ISS in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-10-2020, 09:36 AM
  3. [SOLVED] Index Match over Vlook up
    By MattExcelLearner in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-10-2018, 08:15 AM
  4. [SOLVED] replace vlook up with match or something
    By mmikem in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-22-2018, 03:28 PM
  5. VLook Up Match Formula
    By MrJayB in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-08-2017, 06:46 PM
  6. vlook up return more than one match
    By dphair1979 in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 08-28-2007, 10:46 AM
  7. [SOLVED] Vlook up or index match
    By jerry in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-24-2005, 01:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1