This will become my own page of quick Excel formulas that I find myself looking up elsewhere far too often! It should flesh out over time.
Excel String Manipulation
Does any cell in a range contain a substring?
(Is the string contained in cell F4 a substring of any of the cells in column B)
=COUNTIF(B:B,"*"&F4&"*")>0
Which row number in a range contains the partial match?
=MATCH(""&F4&"",B:B,0)
Return the contents of the column on the same row as the match.
(if the value A6 is found in the column A:A on AMAZON UPLOAD, then return the corresponding value in column O)
=INDEX(O:O,MATCH(A6,'AMAZON UPLOAD.xlsx'!$A:$A,0))
Excel Date Manipulation
Convert the date name into the date number
=MONTH(DATEVALUE(A1&" 1"))