ExcelBanter - use cell reference,whose contents= a table array name for Vlookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - use cell reference,whose contents= a table array name for Vlookup (https://www.excelbanter.com/excel-worksheet-functions/79472-use-cell-reference-whose-contents%3D-table-array-name-vlookup.html)

Sonic

use cell reference,whose contents= a table array name for Vlookup

In my Vlookup function I want to use 1 or 2 cell refernces as a text string
to give the name of my table array.
Microsoft Excel 2002

Ron Coderre

use cell reference,whose contents= a table array name for Vlookup

Without more information, all I can do is point you in what I hope is the
right direction.

Check Excel Help for the INDIRECT function.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

"Sonic" wrote:

In my Vlookup function I want to use 1 or 2 cell refernces as a text string
to give the name of my table array.
Microsoft Excel 2002

Sonic

use cell reference,whose contents= a table array name for Vloo

Ron,

That worked perfctly, thank-you so much for your help.

"Ron Coderre" wrote:

Without more information, all I can do is point you in what I hope is the
right direction.

Check Excel Help for the INDIRECT function.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

"Sonic" wrote:

In my Vlookup function I want to use 1 or 2 cell refernces as a text string
to give the name of my table array.
Microsoft Excel 2002

All times are GMT +1. The time now is 07:51 AM.