Please answer ASAP and show all work and excel formulas such as VLOOKUP

\begin{tabular}{l|l|l|l|} \multicolumn{1}{c|}{ MOIC } & & \multicolumn{1}{|c|}{ COLOR GUIDE FOR MOIC } \\ \hline Company Z & & & Greater than 1.0x \\ Company P & & & Equal to 1.0x \\ Company B & & & Less than 1.0x \\ \hline Company AJ & & & \\ \hline \end{tabular}