| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup on pivot table results = #N/A | Excel Worksheet Functions | |||
| Vlookup in a pivot table | Excel Worksheet Functions | |||
| Change value inside a table, vlookup doesn't recalc automatically | Excel Discussion (Misc queries) | |||
| VLOOKUP - 3 Table Array | Excel Worksheet Functions | |||
| vlookup returns last value in array | Excel Worksheet Functions | |||
Linear Mode
