cell to cell text and link

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set non-continuous PrintArea via Function / Name 0
sun results of a vlookup across a range 3
Comparison of columns using Conditional Formatting 3
Extract Formula to Text 6
Function help required... Between funtion 2
Formula Using Vlookup & Match 3
If OR formula 1
Linking cell ranges between rows and columns 1

Back
Top