if formula to check text and paste link

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

Guest

I want to do the following:

If the cell C2 from file A is equal to cell C2 from file B (Contact person)
AND
cell D2 from file A is equal to cell D2 from file B (Company)
then
copy the content of cell N2 from file A to cell N2 in file B (Notes)

I created a spreasheet of contacts for a co-worker. I gave him a copy of my
spreadsheet. When he writes notes (cell N2) in his spredsheet, I want to see
them in mine. The IF formula is just to check for possible errors that can
occur if he alters his spreasheet in such a way it won't match mine anymore.
 
I figured it out on my own:

=IF(C2='[FileB.xls]Sheet1'!$C$2,IF(D2='[FileB.xls]Sheet1'!$D$2,'[FileB.xls]Sheet1'!$N$2))
 
I figured it out

=IF(C2='[fileB.xls]Sheet1'!$C$2,IF(D2='[fileB.xls]Sheet1'!$D$2,'[fileB.xls]Sheet1'!$N$2))
 

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

Paste formulas and keep them the same 7
Auto-adjusting Formulas 1
copy and paste the cell with formula ="1" 3
Excel 2002: changing link formula from absolute to relative 3
How to do if/then formula with multiple scenarios. 1
IF ERROR FORMULA 1
If condition with text 3
If Formula 15

Back
Top