| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using words in Formulas
I need to use VLookup with a word in the middle linked from another cell. IE: VLOOKUP(A5,(A word from Cell E17),2,FALSE) E17 varies from the results of 2 other cells. But its a word. E17 is =C4&""&C5. In this case it is "FirstStats." So it would be: VLOOKUP(A5,FirstStats,2,FALSE) Anybody know how to link that? -- Lanza52 ------------------------------------------------------------------------ Lanza52's Profile: http://www.excelforum.com/member.php...o&userid=36316 View this thread: http://www.excelforum.com/showthread...hreadid=573485 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
| Number to words literal | Excel Worksheet Functions | |||
| Copying Formulas | Excel Discussion (Misc queries) | |||
| Need Formulas for counting multiple conditions | Excel Worksheet Functions | |||
| Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
Threaded Mode
