| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell to cell text and link
text in cell A3 and text in B3. When cell A3 matches a text in B3, I want to
link cell A3 to another sheet in workbook. How? Bob |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell to cell text and link
In a cell in the other workbook, put this formula.........
=IF(Sheet1!A3=Sheet1!B3,Sheet1!A3,"No match") hth Vaya con Dios, Chuck, CABGx3 "bo" wrote: text in cell A3 and text in B3. When cell A3 matches a text in B3, I want to link cell A3 to another sheet in workbook. How? Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell only shows link in text, not contents of reference cell | New Users to Excel | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Link the value to text in a cell, then use that text cell in a for | Excel Worksheet Functions | |||
| I am trying to link based on a text value instead of cell position | Links and Linking in Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
