Tech Support Guy banner
Status
Not open for further replies.

Multiple IF Statement based on first 3 characters of cell

Solved 
885 views 2 replies 1 participant last post by  gevans 
#1 ·
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
 

Attachments

Status
Not open for further replies.
You have insufficient privileges to reply here.
Top