I have a worksheet with Local and Natl in the same column, I have have created an empy column and want the formula to give me a L if D6 says Local and a N if it says Natl but leave a blank if niether.

Please help

Thanks