need to combine the two tables using VLOOKUP (with an exact match) to create the list using both List 1 and List 2.

Requirement 1: Split the contents of LIST 1 into separate cells. Use functions LEFT, MID, RIGHT, FIND and VALUE as needed.					Requirement 2: Split the contents of LIST 2 into separate cells. Add a column to List 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.)					(Always use cell references and formulas where appropriate to receive full credit.)

List 1					List 2
Security ID	Description	Category	Short-term or Long-term		Security ID	Cost	Fair Value	Lower of Cost or Fair Value
100110	MSFT	TRA	ST		100110	46500	51,000	9,960
100130	ORCL	AFS	LT		100130	17630	16,810	9,960