ExcelBanter - Vlookup on named range

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Vlookup on named range (https://www.excelbanter.com/excel-programming/311140-vlookup-named-range.html)

kev

Vlookup on named range

Anybody got any ideas on how to select the table_array from a list of
them. I have tried to vlookup within the vlookup ie
=vlookup(a1,vlookup(b1,list,2,false),2,false) but it don't like it.

Tom Ogilvy

Vlookup on named range

=vlookup(a1,Indirect(vlookup(b1,list,2,false)),2,f alse)

--
Regards,
Tom Ogilvy

"kev" wrote in message
om...
Anybody got any ideas on how to select the table_array from a list of
them. I have tried to vlookup within the vlookup ie
=vlookup(a1,vlookup(b1,list,2,false),2,false) but it don't like it.

All times are GMT +1. The time now is 11:22 AM.