I can't see what I'm doing wrong here. The formula works in one cell, but not the rest.
I trying to get it to give me a result if B matches N, and R matches E1:J1, then give me the result in Q.
In this sample it works in cell I2, but not the rest?
IF AND PROBLEM.xls
Bookmarks