+ Reply to Thread
Results 1 to 4 of 4

Check if a Table Exists

  1. #1
    Forum Contributor
    Join Date
    11-08-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 2013
    Posts
    128

    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.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,270

    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!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Contributor
    Join Date
    11-08-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 2013
    Posts
    128

    Re: Check if a Table Exists

    Hi, I am using Professional Plus 2016.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,270

    Re: Check if a Table Exists

    Please update your forum profile.

    And in answer to my question about your issue today?

+ 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] 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. 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. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1