ExcelBanter - cell to cell text and link

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - cell to cell text and link (https://www.excelbanter.com/excel-worksheet-functions/107364-cell-cell-text-link.html)

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

CLR

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

All times are GMT +1. The time now is 10:31 AM.