ExcelBanter - use a variable array in a formula

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - use a variable array in a formula (https://www.excelbanter.com/excel-discussion-misc-queries/51336-use-variable-array-formula.html)

JPderose

use a variable array in a formula

I'm trying to use Vlookup and in the table_array, i would like it to be a
cell that has a validation list of the names of several range names

Biff

use a variable array in a formula

Hi!

Try this:

A1 = lookup value
B1 = list of range names

=VLOOKUP(A1,INDIRECT(B1),2,0)

Biff

"JPderose" wrote in message
...
I'm trying to use Vlookup and in the table_array, i would like it to be a
cell that has a validation list of the names of several range names

All times are GMT +1. The time now is 09:45 PM.