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 ?


--
willydlish
------------------------------------------------------------------------
willydlish's Profile: http://www.excelforum.com/member.php...o&userid=19985
View this thread: http://www.excelforum.com/showthread...hreadid=345737

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

.

.