I am working with 2 worksheets within the same workbook. On the first tab I am using a IF formula to evaluate if 2 criteria (on the 2nd tab) are met and if true enter a value from the 2nd tab onto the 1st tab. I can get the formula to work fine but it is very long and am curious if it can be shortened. In the example I am only using 2 machines with the 2 conditions to be met (machine A & B and years2016 - 2019), however I have to evaluate many machines.
Bookmarks