| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLS - HOW Do I use the results of a formula to create NAME to vlookup
XLS - HOW Do I use the results of a formula to create NAME to vlookup E.g cell A5 = "fred" cell b5 = "bloggs" cell C5 contains the formula =a5&b5 sell C5 therefore = fredbloggs fredbloggs is the name of a 2 colunm, 10 row group of cells on another sheet in the same XLS file how do I enure that the value of C5 is used in this formula =vlookup(b11,c5,2) which is of course =vlookup(b11,fredbloggs,2) I'm obviously doing something wrong CB *** Sent via Developersdex http://www.developersdex.com *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
XLS - HOW Do I use the results of a formula to create NAME to vlookup
Use the INDIRECT() function
Look in HELP for details -- Kind regards, Niek Otten "Clive Geezer" wrote in message ... XLS - HOW Do I use the results of a formula to create NAME to vlookup E.g cell A5 = "fred" cell b5 = "bloggs" cell C5 contains the formula =a5&b5 sell C5 therefore = fredbloggs fredbloggs is the name of a 2 colunm, 10 row group of cells on another sheet in the same XLS file how do I enure that the value of C5 is used in this formula =vlookup(b11,c5,2) which is of course =vlookup(b11,fredbloggs,2) I'm obviously doing something wrong CB *** Sent via Developersdex http://www.developersdex.com *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a conditional formula that results in another calculation | Excel Worksheet Functions | |||
| VLOOKUP Shows formula not results. | Excel Discussion (Misc queries) | |||
| i want to create an IF formula to bring back one of four results . | Excel Worksheet Functions | |||
| See results of VLookup formula | Excel Discussion (Misc queries) | |||
| can vlookup place results in a different box than the formula? | Excel Worksheet Functions | |||
Linear Mode
