+ Reply to Thread
Results 1 to 4 of 4

Check if a Table Exists

  1. 01-03-2020, 08:54 AM #1
    mowens74
    mowens74 is offline
    Forum Contributor
    Join Date
    11-08-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 2016
    Posts
    140

    Check if a Table Exists

    Hello,
    I have the following formula
    Please Login or Register  to view this content.
    This formula will be used for 2021 and 2022 but the table is not yet created. Is there a way to reference a table that doesn't exist yet or use an IF statement to say IF table exists then.....?


    Thank you.
    Reply With QuoteRegister To Reply
  2. 01-03-2020, 08:57 AM #2
    AliGW
    AliGW is offline
    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,719

    Re: Check if a Table Exists

    If the table doesn't exist, Excel will try to tell you that you need to access an external workbook. Have you tried naming the range where the table will exist?

    Are you still using Excel 2010?
    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.
    Reply With QuoteRegister To Reply
  3. 01-03-2020, 09:06 AM #3
    mowens74
    mowens74 is offline
    Forum Contributor
    Join Date
    11-08-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 2016
    Posts
    140

    Re: Check if a Table Exists

    Hi, I am using Professional Plus 2016.
    Reply With QuoteRegister To Reply
  4. 01-03-2020, 09:08 AM #4
    AliGW
    AliGW is offline
    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,719

    Re: Check if a Table Exists

    Please update your forum profile.

    And in answer to my question about your issue today?
    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] Check if cell value exists in other table.
    By tiger99 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-31-2019, 02:06 AM
  2. [SOLVED] Check if a value exists in a table
    By Kappany in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-08-2015, 02:42 AM
  3. Check a value from another table exists in cell and return this value.
    By jram in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-06-2015, 02:28 AM
  4. VBA Code to check If value exists in a table
    By ysrikhanta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2012, 05:09 AM
  5. IF assistance to check if value exists in a table first
    By penfold in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-14-2010, 11:46 AM
  6. How can I use VBA ADO to check if a table exists in an Access DB?
    By Ai_Jun_Zhang in forum Excel General
    Replies: 3
    Last Post: 08-24-2005, 04:05 PM
  7. How can I use VBA ADO to check if a table exists in an Access DB?
    By Ai_Jun_Zhang in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-24-2005, 02:52 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1