+ Reply to Thread
Results 1 to 3 of 3

How to use a cell value as Table Array in VLOOKUP worksheet function

  1. #1
    Registered User
    Join Date
    02-15-2005
    Posts
    3

    Question How to use a cell value as Table Array in VLOOKUP worksheet function

    I need to use VLOOKUP for a spreadsheet I'm running and need to use the value in a cell as the name of the table array for VLOOKUP.

    Is this possible ?

  2. #2
    Jason Morin
    Guest

    Re: How to use a cell value as Table Array in VLOOKUP worksheet function

    With the name in A1:

    =VLOOKUP(---,INDIRECT(A1),---,---)

    HTH
    Jason
    Atlanta, GA

    >-----Original Message-----
    >
    >I need to use VLOOKUP for a spreadsheet I'm running and

    need to use the
    >value in a cell as the name of the table array for

    VLOOKUP.
    >
    >Is this possible ?
    >
    >
    >--
    >willydlish
    >---------------------------------------------------------

    ---------------
    >willydlish's Profile:

    http://www.excelforum.com/member.php
    action=getinfo&userid=19985
    >View this thread:

    http://www.excelforum.com/showthread...hreadid=345737
    >
    >.
    >


  3. #3
    Biff
    Guest

    Re: How to use a cell value as Table Array in VLOOKUP worksheet function

    See reply in .Functions

    Biff

    >-----Original Message-----
    >With the name in A1:
    >
    >=VLOOKUP(---,INDIRECT(A1),---,---)
    >
    >HTH
    >Jason
    >Atlanta, GA
    >
    >>-----Original Message-----
    >>
    >>I need to use VLOOKUP for a spreadsheet I'm running and

    >need to use the
    >>value in a cell as the name of the table array for

    >VLOOKUP.
    >>
    >>Is this possible ?
    >>
    >>
    >>--
    >>willydlish
    >>---------------------------------------------------------

    >---------------
    >>willydlish's Profile:

    >http://www.excelforum.com/member.php?
    >action=getinfo&userid=19985
    >>View this thread:

    >http://www.excelforum.com/showthread...hreadid=345737
    >>
    >>.
    >>

    >.
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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