+ Reply to Thread
Results 1 to 2 of 2

VLOOKUP - let the table array be a tablename written in another cell. Is it possible?

  1. #1
    Registered User
    Join Date
    04-02-2020
    Location
    Denmark
    MS-Off Ver
    Office 365
    Posts
    1

    Smile VLOOKUP - let the table array be a tablename written in another cell. Is it possible?

    Hi guys,

    As the title says I want to use the Vlookup function. I can make it work by typing =VLOOKUP(D20,Lassekaas,3,FALSE), where Lassekaas is a named area, D20 is a cell with a text matching a row in Lassekaas and 3 is a column in Lassekaas.
    I want to be able to change the named area by changing the text in a cell and then refer to that cell in the formula instead of writing the name of the area.
    Ive tried to use =VLOOKUP(D20,Indirect("D24"),3,FALSE) where D24 says Lassekaas as a text, but it does not work for me.

    The idea is to be able to change the text in a cell and then find a lot of data in different tables (named areas) based on the text in the cell.

    Hope its not too confusing and you can tell what try to say

    Do any of you know a way to do this, or another way of doing what i try to?
    Thanks in advance,

    Lasse

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,529

    Re: VLOOKUP - let the table array be a tablename written in another cell. Is it possible?

    Try using D24 without the quotes. i.e. INDIRECT(D24)
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

+ 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. Replies: 9
    Last Post: 11-06-2019, 08:56 AM
  2. Change tablename on basis of cell value
    By sanjuss2 in forum Excel General
    Replies: 9
    Last Post: 05-12-2017, 08:01 AM
  3. Replies: 0
    Last Post: 04-06-2017, 02:56 AM
  4. [SOLVED] Using Cell Value for VLOOKUP Table Array
    By kyleflanigan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-03-2014, 09:26 AM
  5. Array formula that uses last written cell
    By dcguerra in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-01-2013, 03:16 PM
  6. INSERT INTO tablename using sql [dynamic table?]
    By swill008 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-18-2013, 10:22 AM
  7. Replies: 2
    Last Post: 02-23-2011, 07:24 AM

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