Iif portion of string exists in one cell, return corresponding column?

[CalianasMamma]

I've been trying to figure this out but I need help!

I want to associate the type of school, based on their email address. My first sheet has a list of email address.

I have another sheet with a list of domains and what type of school it is. Is there a way that I can do some kind of a wildcard search to see if the email address (sheet1, columnA) contains the domain (sheet2, col A), and, if so, return the 'SchoolType' as a result?

Thanks to anyone who can help me! I've been trying but the wildcard part of it really throws me off. I'm looking for case insensitive.

 

[hanifdoc784]

I have a spreadsheet with all values in the first column. The data changes every four rows to a new set of values. I need a function which will transfer a group of four columns into four rows.

Example:

Column values Row values

fred Fred 20 2.5 50kg
20 George 35 7.5 60kg
2.5 Sam 66 8.6 80kg
50kg
george
35
7.5
60kg
sam
66
8.6
80kg