| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use text value inside a formula
I want to grab the text contents of a cell and use that in a formula
in another cell. So, say, for example, A1 contains TEST. Can I then put TEST in a formula automatically in another cell formula, so that the formula will essentially be: =VLOOKUP(A5,[TEST.xls]Sheet1!$A4:$H203,2,FALSE)... I have stock tickers in a cell and filenames named after each ticker and want to do lookups into each ticker's file. The ticker symbols change every day. Any advice appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference text in a cell inside a formula to specify a sheet name | Excel Worksheet Functions | |||
| How to embed large number of variables in text inside a text box? | Excel Discussion (Misc queries) | |||
| using a formula inside a sting of text | Excel Discussion (Misc queries) | |||
| How to make the text inside Text Box upside down? | Excel Discussion (Misc queries) | |||
| Need macro to insert text string while inside cell (formula) | Excel Discussion (Misc queries) | |||
![Gary[_17_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
