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 ?
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 ?
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
>
>.
>
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
>>
>>.
>>
>.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks