If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
linking excel docs
I have linked 3 excel docs which have about 90% similar formatting and
formulas. in these docs i have a list of questions which differ slightly and I would like to have columns with similar question to input in all three excel docs. e.g question 1 in all three docs is the same, question 2 is different across them. if answer in question 1 doc 1 is genius to have an automatic input in doc 2 and doc 3. Any suggestions on this (please note that these columns have an existing formula), thanx |
#2
|
|||
|
|||
linking excel docs
If I really understood your problem, you can add in your answear column of
doc2 and doc3 something like this: =IF(OR(A2="",A2=0),"",IF(ISNA(VLOOKUP(A2,doc1_colu mn_A,1,0)),"",VLOOKUP(A2,doc1_column_A,1,0))) -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy (now in Berlin)GENO wrote: I have linked 3 excel docs which have about 90% similar formatting and formulas. in these docs i have a list of questions which differ slightly and I would like to have columns with similar question to input in all three excel docs. e.g question 1 in all three docs is the same, question 2 is different across them. if answer in question 1 doc 1 is genius to have an automatic input in doc 2 and doc 3. Any suggestions on this (please note that these columns have an existing formula), thanx |
Thread Tools | |
Display Modes | |
|
|