Jun 02 2022 07:38 AM
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?