Okay I have another sophisticated lookup question I need to get some help with...
I have an XLS with multiple tabs
I am working from a tab called all deals which has a column "C" called account name
I also have a tab called mapping which has column "A" called account name
I need a formula that is copy the contents of mapping:C into all deals:L when mapping:A = all deals:C