Hi all, i have an issue with using the if formula in conjuction with an array.
In sheet 2 i have an array explaining what i need. So for code 1,2,5 attention is Y and for 3,4,6 is N.
I need a formula in sheet 1 column F which checks the code that is in column D and provides Y or N in column F, but only if the amount is above 1500.
Is that possible.
Bookmarks