EXCEL master, a few questions need help, thank you!

1. Establish a cross-reference table of names and companies, and look it up with vlookup.

2. Establish a time and depreciation comparison table, or a conversion formula. The comparison table uses vlookup, and if the conversion formula is used, E= formula (d).

3. Same as 2

4. Same as 2

5. Summary can be indirect, for example, a three-zone C4 cell = indirect ($ B4&; "! C28 "), set the corresponding cell colon in three pages.