Vlookup -Want to make table of array optional
 

hi All,

Can anyone let me know how to make the table of array optional in
Vlookup formula.

thanks

Karthik

Vlookup -Want to make table of array optional
 

Assume you mean make the table array flexible ?
You could use INDIRECT to string it up
Eg if you have named table arrays (eg: 1Base, 2Base, 3Base, etc)
and A2 house the value: 1 or 2 or 3, etc,
then something like this would work:
=VLOOKUP(K2,INDIRECT(A2&"Base"),3,0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Karthik" wrote in message
oups.com...
hi All,

Can anyone let me know how to make the table of array optional in
Vlookup formula.

thanks

Karthik

Vlookup -Want to make table of array optional
 

Hi Max,

Thanks a lot... Its working...

Regards,

Karthik
India

Max wrote:
Assume you mean make the table array flexible ?
You could use INDIRECT to string it up
Eg if you have named table arrays (eg: 1Base, 2Base, 3Base, etc)
and A2 house the value: 1 or 2 or 3, etc,
then something like this would work:
=VLOOKUP(K2,INDIRECT(A2&"Base"),3,0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Karthik" wrote in message
oups.com...
hi All,

Can anyone let me know how to make the table of array optional in
Vlookup formula.

thanks

Karthik

Vlookup -Want to make table of array optional
 

You're welcome, Karthik !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Karthik" wrote in message
ups.com...
Hi Max,

Thanks a lot... Its working...

Regards,

Karthik
India