I'm sure that this problem has already been addressed, however, I could not find a post answering my question. Could someone please reply to this response with a link to the corresponding post. Thank you.
If the question has not already been asked the following are my formulas:
=(IF(ISNA(VLOOKUP($B88,'exec data'!$A$5:$O$51,6,FALSE)),0,VLOOKUP($B88,'exec data'!$A$5:$O$51,6,FALSE)))
+
(IF(ISNA(VLOOKUP($B88,'10 Reorg Data'!$A$5:$O$51,6,FALSE)),0,VLOOKUP($B88,'10 Reorg Data'!$A$5:$O$51,6,FALSE)))
Both equations work alone, however, I would like the resluts of both "summed" in the same cell. (i.e. the first equation results in 1 and the second equation results in 1, therefore 2 should be the answer 1+1=2)
Thank you for your time.
-Dave
If the question has not already been asked the following are my formulas:
=(IF(ISNA(VLOOKUP($B88,'exec data'!$A$5:$O$51,6,FALSE)),0,VLOOKUP($B88,'exec data'!$A$5:$O$51,6,FALSE)))
+
(IF(ISNA(VLOOKUP($B88,'10 Reorg Data'!$A$5:$O$51,6,FALSE)),0,VLOOKUP($B88,'10 Reorg Data'!$A$5:$O$51,6,FALSE)))
Both equations work alone, however, I would like the resluts of both "summed" in the same cell. (i.e. the first equation results in 1 and the second equation results in 1, therefore 2 should be the answer 1+1=2)
Thank you for your time.
-Dave