Please provide me with the exact VLOOKUP formulas to complete the Combined Lists

the Formula I used for the Security ID column is

=VLOOKUP(B36:B47,G36:J47,1,FALSE)

A B C D E F G Requirement 1: Split the contents of LIST 1 into separate cells. Use functions LEFT, Requirement 2: Split the contents of LIST 2 into separate cells. Add a column to List MID, RIGHT, FIND and VALUE as needed. 2 that calculates the lower of cost or fair value by security using the function MIN. (Always use cell references and formulas where appropriate to receive full credit. If (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab, you will be marked wrong.) you copy/paste from the Instructions tab, you will be marked wrong.) \begin{tabular}{|l|l|l|l|} \hline \multicolumn{3}{|c|}{ List 1 } \\ \hline Security ID & Description & Category & Short-term or Long-term \\ \hline 100230 & PRCL & AFS & LT \\ \hline 100210 & NSFT & TRA & ST \\ \hline 100240 & JNTU & TRA & LT \\ \hline 100250 & BDBE & AFS & ST \\ \hline 100260 & DSCO & AFS & ST \\ \hline 100270 & BMZN & TRA & ST \\ \hline 100290 & BAPL & TRA & ST \\ \hline 100310 & QANW & AFS & LT \\ \hline 100340 & DHKP & TRA & ST \\ \hline 100350 & UBIL & HTM & ST \\ \hline 100360 & UBIL & HTM & ST \\ \hline 100370 & UNOT & HTM & LT \\ \hline \end{tabular} Requirement 3: Create a new list of securities that has Description, Category, Short-term or Longterm, and Lower of cost or Fair Value. Use VLOOKUP (with an exact match) to create the list using both List 1 and List 2. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab, you will be marked wrong.) \begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{5}{|c|}{ Combined Lists } \\ \hline Security ID & Description & Category & Short-term or Long-term & Lower of Cost or Fair Value \\ \hline 100230 & & & & \\ \hline 100210 & & & & \\ \hline 100240 & & & & \\ \hline 100250 & & & & \\ \hline 100260 & & & & \\ \hline 100270 & & & & \\ \hline 100290 & & & & \\ \hline 100310 & & & & \\ \hline 100340 & & & & \\ \hline 100350 & & & & \\ \hline 100360 & & & & \\ \hline 100370 & & & & \\ \hline \end{tabular}