Lookup

[reeser]

I have 2 sets of data that I'm trying to find a certain value from.

I have a column of numbers in AG and a column in M. If the value appears in both columns, then I would like a 1 to show up in column AL.

I have tried several lookups and if formulas but nothing is giving me the result I'm after.

Any suggestions?

 

[Aladin Akyurek]

I have 2 sets of data that I'm trying to find a certain value from.

I have a column of numbers in AG and a column in M. If the value appears in both columns, then I would like a 1 to show up in column AL.

I have tried several lookups and if formulas but nothing is giving me the result I'm after.

Any suggestions?

=ISNUMBER(MATCH(M2,AG:AG,0))+0

if column AG is the longest...

=ISNUMBER(MATCH(AG2,M:M,0))+0