Hi Craig
You haven't allowed for a FALSE condition
Try this:
=IF(AND(K20:K632="450300",N20:N632="SM1-Assy",N20:N632="SM2-Assy"),O20,"nothing")

and use Ctrl Shift Enter to make it an array

HTH
Michael M

"Craig Koon" wrote:

Can anyone please review and correct formula to work for me. Unable to get it
right. Too stumped to continue. Ready to pull last hairs out....

=IF(AND(K20:K632="450300",N20:N632="SM1-Assy",N20:N632="SM2-Assy"),O20,)



Thanks