cell to cell text and link

B

bo

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
 
C

CLR

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
 
Top