+ Reply to Thread
Results 1 to 3 of 3

Xlookup - Tables and Referencing a cell

  1. #1
    Registered User
    Join Date
    10-21-2020
    Location
    Leeds
    MS-Off Ver
    365
    Posts
    3

    Xlookup - Tables and Referencing a cell

    Hi

    This xlookup works =XLOOKUP(A4,Table1[Employee ID],Table1[PM Certification])

    However I have several columns and don't want to keep changing the "PM Certificate" for each column I want to reference. I want to use the cell which has that work in it.

    I have tried =XLOOKUP(A5,Table1[Employee ID],"Table1["&G2&"]") which returns a #VALUE error.

    Can you help with the syntax - thx

  2. #2
    Forum Contributor
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    342

    Re: Xlookup - Tables and Referencing a cell

    Hi - can you attach your file?

  3. #3
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,366

    Re: Xlookup - Tables and Referencing a cell

    If you have the field name in cell G2,

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Tangential rant. IF MSFT had ever revised DGET to be similar to @DGET from Lotus 1-2-3 Release 3 or later, one could use something like

    =DGET(Table1,G2,"[Employee ID]="&A4)

    Then again, if MSFT were willing to allow the 3rd argument to DGET to be an array, as in Google Sheets, it'd be possible to use

    =DGET(Table1,G2,{"Employee ID";""}&LEFT(A4,{0;255}))

    Alas, MSFT's Excel Developer Team is still severely afflicted with NIH Syndrome. At least they were willing to steal FILTER, SORT and UNIQUE from Google Sheets.

+ 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. [SOLVED] Using xlookup/vlookup formula into a validated cell to return a value into that cell
    By Questray in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-14-2020, 11:51 AM
  2. Xlookup for first word in cell?
    By haskenazi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2020, 02:05 PM
  3. Replies: 2
    Last Post: 03-22-2020, 09:05 PM
  4. Referencing multiple tables
    By Advanced Automated in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 10-11-2017, 02:59 PM
  5. Replies: 19
    Last Post: 04-04-2016, 02:58 PM
  6. Referencing to tables
    By The Guy in forum Excel General
    Replies: 2
    Last Post: 03-05-2009, 04:13 AM
  7. referencing two tables
    By spog00 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-05-2005, 07:57 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