Trizoy

Hello everyone,
I was hoping someone could help on this.

I am creating a template for Excel, and I have many functions in a few columns to search for and extract key information. These functions are only able to be defined by column name.

For example:
A regular function would be
=A2+B2
a TEMPLATE function would be
='column'+'column2'

They mean the same thing.

Now I need to write a comparison function which would compare a value in 1 row to another.

For example:
=IF(AND(A1=A2,G3<G3),"NADA",C2)

Is the same as this

=IF(AND('column1'={'column2':row3},'column7<{'column2':row3}),"nothing",'column2')

How do I define a row when im using the column header name?
Sorry Im new to this.

Thanks!

__________________
01100110 01100001 01110010 01110100