Results 1 to 13 of 13

XLOOKUP or FILTER matrix result expected but #VALUE! returned

Threaded View

  1. #1
    Registered User
    Join Date
    01-29-2024
    Location
    Amsterdam
    MS-Off Ver
    365
    Posts
    29

    XLOOKUP or FILTER matrix result expected but #VALUE! returned

    I'm using a XLOOKUP formula in a set of formulas and values that are part of the LET(...) function. I'm trying to get matching results for each row in a matrix which are searched in a second table. I believe the problem is that the formula doesn't do the match on a row by row basis, but tries to match all values at the same time.

    In other words what I'm trying to do here, is "for each row in the column of the matrix, find the corresponding value in table TAA" Only one value should match in the TAA table based on the used criteria.

    I tried to get the results by using the FILTER formula, but this also caused the #VALUE! error. In buth attempts, when I'm using a fixed value for each criteria, it works without errors (for example

    (TAA[taa_year]=2023)*(TAA[taa_month]=3)
    I enclosed the sample sheet. The results are used as source for a graph in Excel.

    How can I get this working?

    Art.
    Attached Files Attached Files
    Last edited by dxfoxd; 04-19-2024 at 05:31 PM. Reason: Adding variables problem returned

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Show left chars of xlookup result with conditions on return result
    By Tech980 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-11-2023, 07:15 AM
  2. [SOLVED] Xlookup not working as expected
    By northernwarrior in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-24-2023, 04:59 PM
  3. Replies: 11
    Last Post: 04-14-2023, 12:50 PM
  4. [SOLVED] XLOOKUP lookup_value is a returned value of a formula
    By sussington in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-17-2023, 05:53 PM
  5. [SOLVED] XLOOKUP Row and Col not finding matching value in Matrix.
    By Ochimus in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-22-2023, 02:29 PM
  6. [SOLVED] Matrix Lookup Multiple Critera returned in single cell
    By NotSwank in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 06-18-2021, 02:55 PM
  7. [SOLVED] Advanced Filter gives not the expected result
    By Harry_1101 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-05-2021, 09:59 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