Hi All,
I'm trying to use an IF function to have cells update between two workbooks but keep ending up with blank cells. For example:
Book 1
A B C 501 Carly AA 362 Robert AL 441 Ted AA 468 Mac AR
Book 1 is the "master" copy and I want to link back to this from the new workbook. I want to be able to separate some people out (say Robert and Tim only) and have the corresponding information in column C (the text "AA" or "AL" or "AR") update whenever Book 1 is altered.
I have tried using the formula:
=IF(A1=Book1!$A:$A, Book1!C:C, " ")
So, if the ID in column A matches the ID in book 1 the corresponding value in cell C for that row should be copied across. But all I end up with is blank cells all the time. Is this because I'm trying to use a formula to copy text? Or am I doing something else wrong?
Any help is much appreciated!
Bookmarks