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?
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?