Forum Discussion
IF Formula trouble
Hi All
I have a formula which lists names looking at a criteria in a cell.
=IFERROR(INDEX('Year 5'!$A$3:$A$62,SMALL(IF('Year 5'!$C$3:$C$62="1",ROW('Year 5'!$A$3:$A$62)-ROW('Year 5'!$A$3)+1),ROWS(C$4:C4))),"")
I now want to be able to add an and in. I want the formula to list names that have a 1 in cells c3:c62 and have a 1 in cells I3:I62
Im sure this is simple for someone but I cant get it to work.
Thank you
Ian
10 Replies
Hello,
have you tried using Countif formula?
=countif('Year 5'!$A$3:$A$62, $A1)
the second range should be the staring cell address of your second list. If the formula returns 1 or more then this name is already exists in your main table.
Hi
I am not wanting to count the names. The formula at the moment looks at the list of names in a3:a62 and makes a new list of any names that have a one in their corresponding cell in column c. I still want to return the names but the ones that have a 1 in column c and column I.
Hello,
can you add your excel file? and describe what you want to achive? As I have understood you have C and I colomns with some values. and you want to look for names where there is 1 on the correspondig cells in C and I column? Is it correct?
