Please provide me with all 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)

Requirement 1: Split the contents of ust 1 into separate cells. Use functions LeFT, MiD, RGCRT, HiND and VALUE as needed. Requirement 2 . Solit the contents of ust 2 into seperate cells. Add a column to List 2 (Aways use cell references and formulas where approptiate to receive full ciedit. if that calcutstes the lower of cost of fair value by security using the function MON you copW/paste from the instructions tab, you will be marked wrone.l (Always use cell references and formulas where appeopriate to receive fult credit if vou copyaste from the instructions tob, you will be maked wronge Hequirement 3: Create a new list of securities that has Description, Category, 3hartterm or lont term, and tower of cost or fair Value. Use viookup (with an exact maich) to create the list wing both tist 1. and List 2 (Always use cell references and formulas where approptiate to recene full credit. If you copvipaste. Irom the instructions tab, you will be marked wrone.)