Name	Date Paid	Amount	State
	Wellington	5/18/2012	$150.00	Virginia
	Texas Instruments	4/1/2013	$75.00	Texas
	BAE	8/20/2011	$20.00	New Mexico
	Lockheed Martin	9/15/2012	$100.00	California
	Instructions:
	Create an excel formula on cells C12, C13, and C14 that will extract the "Date Paid", "Amount", and "State" from the list above based on the name in C11. NOTE: If the value in C11 changes to a different name from the list, the values should update automatically.
	Name	Wellington
	Date Paid
	Amount
	State
	I have attached an image of the question

ABCDE Instructions: Create an excel formula on cells C12,C13, and C14 that will extract the "Date Paid", "Amount", and "State" from the list above based on the name in C11. NOTE: If the value in C11 changes to a different name from the list, the values should update automatically. \begin{tabular}{|l|l|} \hline Name & Wellington \\ \hline Date Paid & \\ \hline Amount & \\ \hline State & \\ \hline \end{tabular}