| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link cells with text not numbers
I'm working with a worksheet of cells with general information (text) that I
linked to various cells on worksheets within a workbook. I created the formula below and it works but I'm not sure it is the most accurate way to write the formula. =IF('General Info'!C20,'General Info'!C2,"") All linked cells contain text, not numbers, so I'm questioning the 0. Any better alternatives? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| link text cells on different sheets | Excel Worksheet Functions | |||
| How do you link cells containing text? | Excel Worksheet Functions | |||
| how do I link text cells to another worksheet | Excel Discussion (Misc queries) | |||
| Using text in cells to build a link to within another file | Excel Discussion (Misc queries) | |||
| External link only works for numbers -- for text values, #N/A is displayed unless linked file is open | Links and Linking in Excel | |||
Threaded Mode
