Non-standard solution of the problem in Excel?

Question

excel

Hi all.
Please tell me which formula to use
There is Sheet1, in column F there are 16 variations of values ​​\u200b\u200b(text), how to transfer these values ​​​​to Sheet2, after changing them to the desired text value:
Example: The first column is a selection of 16 variations for each (2nd column) has its own Type, it is necessary that the formula, depending on the variation (from Sheet1), transfers to Sheet2 the Type corresponding to it.
Internet - Internet
ATV - KTV
DTV - KTV
Dobandl Internet - Internet
Migration - KTV

Answer 1

Read about the VLOOKUP () function, it should cope.

Answer 2

There are certain tasks in column F on the "reports" sheet, they need to be transferred to column F on the "Address" sheet, but you need to transfer the corresponding Types to which they belong. Correspondence of Tasks to their Types on the "Data" Sheet...