Hello,
I am using Excel 2010 and trying to resolve an if statement... in the file attached I require the following:
I need 1 of 3 results for cell G2 based on the first 3 characters of cell B2
M15### would equal PAB
M22### would equal NSY
Non# would equal None
Thanks
I am using Excel 2010 and trying to resolve an if statement... in the file attached I require the following:
I need 1 of 3 results for cell G2 based on the first 3 characters of cell B2
M15### would equal PAB
M22### would equal NSY
Non# would equal None
Thanks