M
mkz
I have 2 worksheets i'm working i
Basically in sheet 2 I have a schedule of payees and which months the
need to be paid in. Months are in row 1, payees in column A. Then ther
are x's in the months that that payee needs to be pai
In sheet one, i have payees listed in a row, along with other info i
rows below. Anyway, the point is payees are listed in row form i
sheet1, as opposed to column form in sheet2
On sheet1, I have a drop down list of months. I want to be able to pic
a month, and then have it tell me if the payee in the same column has
payment due that month or not. Preferably, it would output a "Yes/No"
but it would also be fine/probably easier to have it output "1/0
I've tried various counts and sumproducts and array formulas, but n
luck. I'm thinking maybe it has to do with some of the criteria bein
listed in a row, others listed in a column?
Any help is appreciated! Thanks
Basically in sheet 2 I have a schedule of payees and which months the
need to be paid in. Months are in row 1, payees in column A. Then ther
are x's in the months that that payee needs to be pai
In sheet one, i have payees listed in a row, along with other info i
rows below. Anyway, the point is payees are listed in row form i
sheet1, as opposed to column form in sheet2
On sheet1, I have a drop down list of months. I want to be able to pic
a month, and then have it tell me if the payee in the same column has
payment due that month or not. Preferably, it would output a "Yes/No"
but it would also be fine/probably easier to have it output "1/0
I've tried various counts and sumproducts and array formulas, but n
luck. I'm thinking maybe it has to do with some of the criteria bein
listed in a row, others listed in a column?
Any help is appreciated! Thanks