1. Based on the following formulas, state what data the formula would return in each cell (on Sheet 1):

1)B2 =vlookup(A2, Sheet2!B:D, 3, FALSE)

2)C3 =vlookup(A3, Sheet2!B:E, 4, FALSE)

3)E6 =vlookup(A6, Sheet2!B:C, 2, FALSE)

4)B4 =vlookup(A4, Sheet2!A:C, 3, FALSE)

5)C5 =vlookup(A5, Sheet2!B:E, 1, FALSE)

6)D3 =vlookup(A3, Sheet2!A:B, 1, FALSE)

7)B6 =vlookup(A6, Sheet2!B:D, 4, FALSE)

8)C2 =vlookup(A2, Sheet2!C:E, 3, FALSE)

9)E7 =vlookup(A7, Sheet2!B:C, 2, FALSE)

MRN 93493 60020 55080 74340 92936 80681 88505 70313 78031 61415 73225 57018 83605 79278 56311 70264 99898 62856 56411 59458 59177 65167 87850 82603 DOB Ethnic 2 05/25/1983 3 08/16/1999 409/24/1976 503/14/2008 6 05/03/1992 7 06/31/1956 8 02/29/2000 Clotrimazole 125 mg/5 ml buprofen Amoxicillin Naproxen Finasteride Gabapentin Terconazole Amlodipine Fluoxetine Carvedilol Carbamazepine Metformin 125 m/5 ml 375 200 Asian 10 04/21/1966 1106/05/2011 12 09/16/1957 13 06/14/1992 14 08/13/1940 15 01/13/1999 16 03/14/1984 17 04/06/1973 18 05/21/1962 941 20 06/11/1945 21 12/16/1966 20 mg 12.5 m 100 Asian 100 Units/ml 200 Fluvoxamine Risperidone Acetaminophen Lorazepam Diltiazemm 625 125 mc 23 06/16/1967 10/5/1950 25 08/29/1975 Loratadine Fluconazole Quetiapine Atorvastatin 150 200 Sheet 2 MRN 65167 70313 61415 56411 78031 46983 87850 Sheet 1 DOB Ethnicit