'Modify Maxif statement
=MAX(IF($A$1:$A$2000=AFM!AC8,$F$1:$F$2000))
So the code above is supposed to look through the range $A$1:$A$2000 in my current sheet and see if any of the values in that range is equal to a value in the range of cells in my other sheet named AFM( in this example the cell AC8 is the selected cell the selected range range in my AFM sheet is the column AC) it will then grab the corresponding value on the range $F$1:$F$2000 from my current sheet and paste it on another range in my current sheet. Currently the formula is working but when there are no matches between the ranges $A$1:$A$2000 in my current sheet and the selected range in my AFM sheet it prints out a 12:00 AM because the values in range $F$1:$F$2000 are time stamps. How do I add to the formula so it prints out N/A for the values that don't have any matches between the ranges $A$1:$A$2000 and AC in my AFM sheet?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
