Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlookup
Is there a way to convet a text string into an array reference?
I would like to store the second argument to Vlookup (array reference) in a cell. Example: Vlookup("Foo",D3, 7,) where D3 has the following text:"Costs!D4". When I use this Vlookup returns a N/A error. Thanks. |
#2
|
|||
|
|||
2 problems
1. costs!d4 and :x15 or whatever the rest of the range is 2. Vlookup("Foo",indirect(D3),7,) -- Don Guillett SalesAid Software "AR" wrote in message ... Is there a way to convet a text string into an array reference? I would like to store the second argument to Vlookup (array reference) in a cell. Example: Vlookup("Foo",D3, 7,) where D3 has the following text:"Costs!D4". When I use this Vlookup returns a N/A error. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup finds a blank, but returns a zero - HELP! | Excel Discussion (Misc queries) | |||
Vlookup Syntax Error | New Users to Excel | |||
Need help with modifying VLookUp | Excel Discussion (Misc queries) | |||
Using Cell references in VLookUp | Excel Worksheet Functions | |||
vlookup. | Excel Worksheet Functions |