Results 1 to 4 of 4

Xlookup table references and different worksheets

Threaded View

  1. #1
    Registered User
    Join Date
    07-31-2024
    Location
    Seattle, Washington
    MS-Off Ver
    Microsoft 365
    Posts
    2

    Xlookup table references and different worksheets

    Hello,

    This is my first post and I'm hoping for some help with XLOOKUP, table references, and looking from one to another sheet.

    I want to make a formula that will produce the Subtask Name (from the Project Info Table on a different sheet which has Task and Subtask Numbers and Names) based on the Task Number and Subtask Number entered on my Task Tracking Table.
    The simpler Task Name formula, which produces the Task Name from the Project Info Table based on only the Task Number, works as expected.

    The problem I'm having is the formulas in Table1, Subtask Name (G4:G10) on the Task Tracking sheet on the uploaded document. I need to use table references because the Project Info Table (Table2) must be a table-in the actual document it is a power query table so depending on the project being queried, it could be different sizes. In the actual document, I've made the data types and formats "Text" for all the Task Number and Subtask Number fields to allow leading zeroes because that's the output from the query. I wrote all the formulas for ranges that aren't tables to troubleshoot, and these work, so I think I'm making some mistake in table references?

    Any information will be helpful. I would be happy with XLOOKUP, MATCH/INDEX, or any other solution. Thanks!

    Matt VB
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help with xlookup combined with index match and table references
    By phpolicylady in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-11-2023, 01:45 PM
  2. Replies: 2
    Last Post: 11-26-2021, 10:39 PM
  3. [SOLVED] XLOOKUP not picking up table references while constructing a formula
    By Questray in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2021, 12:31 PM
  4. Replies: 1
    Last Post: 05-27-2020, 12:20 AM
  5. [SOLVED] References In Object Formulas Must Be External References To Worksheets Error
    By zanshin777 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-28-2015, 07:40 AM
  6. Copying Worksheets and Updating References to Other Worksheets Automatically
    By TheScott in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-15-2015, 02:08 PM
  7. Replies: 6
    Last Post: 06-02-2014, 01:40 PM

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