Forum Discussion
interco60
Jun 02, 2022Copper Contributor
conditional formula using named range of cells references whole range not single cell?
something has changed ?..i want to compare a named row range with a named column range...and ,conditional on match or not,, / place content of a third name range cell on same row, or else zero
This now seems to referece not cell on this row within the named range but tries to insert the whole column name range
I am in Row 7, Col G
I specify content as "if code in Row7,Colb = code in Row A, Co G (above), then enter the number in Row 7 Col Cm, if not, enter 0
if(name1=name2,data1,0)
Why doesnt this conditional formula work?
No RepliesBe the first to reply