I need help finding the depreciable life using the Xlookup function so I need that formula and I also need the formula for Vlookup in column G.

Wayne Enterprises Depteciation schedule Directions Fil in Columes F M using formulas. Use an Xlook tp function for columef anda Vlockup for columns G. Also, on For the Year inded 12/11/2010 sheet2 summarze the depreciation expense by type uaing a pivot table. Itema Destipban Type Date Purchsyed Orginal Coit Deprecuble life salvage Value Percentage Salvege value Annual oepreciatian Actumulated Depreci. Sheet2 summarue the depredatice expense by type using a plot table. Depreciable tife Salvage value Percentage Salvace Value Anouat Degreciation Accumalated Depreciation 12/31/2009 bock Value. Depredation Expense 12/31/20t0 sok Value