conditional formula using named range of cells references whole range not single cell?

%3CLINGO-SUB%20id%3D%22lingo-sub-3460490%22%20slang%3D%22en-US%22%3Econditional%20formula%20using%20named%20range%20of%20cells%20references%20whole%20range%20not%20single%20cell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3460490%22%20slang%3D%22en-US%22%3E%3CP%3Esomething%20has%20changed%20%3F..i%20want%20to%20compare%20a%20named%20row%20range%20with%20a%20named%20column%26nbsp%3B%20range...and%20%2Cconditional%20on%20match%20or%20not%2C%2C%20%2F%20place%20content%20of%20a%20third%20name%20range%20cell%20on%20same%20row%2C%20or%20else%20zero%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20now%20seems%20to%20referece%20not%20cell%20on%20this%20row%20within%20the%20named%20range%20but%20tries%20to%20insert%20the%20whole%20column%20name%20range%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20in%20Row%207%2C%20Col%20G%3C%2FP%3E%3CP%3EI%20specify%20content%20as%20%22if%20code%20in%20Row7%2CColb%20%3D%20code%20in%20Row%20A%2C%20Co%20G%26nbsp%3B%20(above)%2C%20then%26nbsp%3B%20enter%20the%20number%20in%26nbsp%3B%20Row%207%20Col%20Cm%2C%20if%20not%2C%26nbsp%3B%20enter%200%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif(name1%3Dname2%2Cdata1%2C0)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20doesnt%20this%20conditional%20formula%26nbsp%3Bwork%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3460490%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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? 

 

 

 

0 Replies