help on vlookup fuction

  • Thread starter Thread starter chinaprasad
  • Start date Start date
C

chinaprasad

Hi,

i created a data with a name say a1:d7 as "info"

when i make a vlookup function i wanted to use this data i.e "info" a
arry in the funciton.

if i type as info i will get the vlookupdata. but.

i need help on the following

"info" the name for data is in cell e1, i want to use the info withou
typing directly in vlookup function, but i want use with reference o
e1,
if i chage the data to some thing else that data name should be take
in vlookup...

is there any possiblity plz let know.. it will b very use for me..

thanx and regd.
CN
 
Hi
if I understood you correctly try something like the
following:
=VLOOOKUP(value,INDIRECT(E1),col_index,0)
 
Back
Top