I have a table divided by months with rows of data. I'm currently using this formula to subtract two different months from each other of a specific item.
=IF(ISNUMBER(MATCH(CONCATENATE($B6,$B$2,D$5),All_Data!$D:$D,0)),LOOKUP(CONCATENATE($B6,$B$2,D$5),All_Data!$D:$D,All_Data!$F:$F),0)-IF(ISNUMBER(MATCH(CONCATENATE($B6,$B$2,D$32),All_Data!$D:$D,0)),LOOKUP(CONCATENATE($B6,$B$2,D$32),All_Data!$D:$D,All_Data!$F:$F),0)
What I want to do is if neither of those find a number to have it say "No Data." I currently have it set to show 0 if the value doesn't exist in each lookup. The reason is because if one of the values still can be looked up, I need to still subtract it from 0.
I need a way to set it up if NEITHER value exist that it'll say "No Data"
Thank you.
Bookmarks