70.2K
Verified Solution
Link Copied!
please correct vlookup formula

\begin{tabular}{|c|c|c|c|c|} \hline & fx= VLOOK & \multicolumn{2}{|c|}{= VLOOKUP(A31,\$A\$16:\$D\$23,4,FALSE) } \\ \hline & A. & B & C & D \\ \hline 20 & 5 & & 11.52% & 8.93% \\ \hline 21 & 6 & & 5.76% & 8.92% \\ \hline 22 & 7 & & & 8.93% \\ \hline 23 & 8 & & & 4.46% \\ \hline \multicolumn{5}{|l|}{24} \\ \hline 25 & Asset: & \multicolumn{2}{|c|}{ Industrial Refrigeration Equipment } & \\ \hline 26 & Class Life: & & 70 & \\ \hline 27 & Basis: & $1,434,214 & & \\ \hline \multicolumn{5}{|c|}{28} \\ \hline 29 & \multicolumn{3}{|c|}{ Depreciaiton } & \\ \hline 30 & Year & Rate & Amount & \\ \hline 31 & & 14.29% & $204,949.18 & \\ \hline 32 & & 24.49% & $351,239.01 & \\ \hline 33 & & 17.49% & $250,844.03 & \\ \hline 34 & & 12.49% & $179,133.33 & \\ \hline 35 & & 8.93% & $128,075.31 & \\ \hline 36 & & 8.92% & $127,931.89 & \\ \hline 37 & & 8.93% & $128,075.31 & \\ \hline 38 & & 4.46% & $63,965.94 & \\ \hline 39 & & Total & $1,434,214.00 & \\ \hline 40 & & & & \\ \hline 41 & & Fully Depreciated? & Yes & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline & fx= VLOOK & \multicolumn{2}{|c|}{= VLOOKUP(A31,\$A\$16:\$D\$23,4,FALSE) } \\ \hline & A. & B & C & D \\ \hline 20 & 5 & & 11.52% & 8.93% \\ \hline 21 & 6 & & 5.76% & 8.92% \\ \hline 22 & 7 & & & 8.93% \\ \hline 23 & 8 & & & 4.46% \\ \hline \multicolumn{5}{|l|}{24} \\ \hline 25 & Asset: & \multicolumn{2}{|c|}{ Industrial Refrigeration Equipment } & \\ \hline 26 & Class Life: & & 70 & \\ \hline 27 & Basis: & $1,434,214 & & \\ \hline \multicolumn{5}{|c|}{28} \\ \hline 29 & \multicolumn{3}{|c|}{ Depreciaiton } & \\ \hline 30 & Year & Rate & Amount & \\ \hline 31 & & 14.29% & $204,949.18 & \\ \hline 32 & & 24.49% & $351,239.01 & \\ \hline 33 & & 17.49% & $250,844.03 & \\ \hline 34 & & 12.49% & $179,133.33 & \\ \hline 35 & & 8.93% & $128,075.31 & \\ \hline 36 & & 8.92% & $127,931.89 & \\ \hline 37 & & 8.93% & $128,075.31 & \\ \hline 38 & & 4.46% & $63,965.94 & \\ \hline 39 & & Total & $1,434,214.00 & \\ \hline 40 & & & & \\ \hline 41 & & Fully Depreciated? & Yes & \\ \hline \end{tabular}
Answer & Explanation
Solved by verified expert