According to the partial worksheet below, a formula $=$ VLOOKUP $($D$3,$ lookup array, index$)$ is written in cell E$3$

and copied down column E to obtain the amount of Tylenol each person in the Dataset can have in a single dose. For the desired results, what should lookup$\_$array refer to$,$ and what should be the value of index?

D

F

G

L

$1$

$2$

$3$

$4$

$5$

$6$

$7$

$8$

$9$

ID

$551321$

$551322$

$551323$

$551324$

$551325$

$551326$

$551327$

Name

Roxy

Lana Bruce

Tara Flora

Silia Emily

Dogs Dataset

Lookup Array: Single Glucosamine Dose

Gender Age $($year$)$ Amount $($tsp$)$

Category Age Range $($Year$)$

Age

Weight$($lb$)$ Amount$($tsp$)$ Amount$($mL$)$

Female

$6$

$1$

age$<2$

Ib$<20$

$0\mathrm{.}41$

$2$

Female

$2$

$2$

$25$age$<3$

$2$

$205$lb$<30$

$0\mathrm{.}91$

$4\mathrm{.}5$

Male

$3\mathrm{.}5$

$3$

$3$sage$<4$

$3$

$305$lb$<40$

$1\mathrm{.}01$

$5$

Female

$2\mathrm{.}5$

$4$

$4$sage$<5$

$4$

$505$lb$<60$

$1\mathrm{.}62$

$8$

Female

$14$

$5$

$5$sage$<6$

$5$

$60$slb$<70$

$1\mathrm{.}93$

$9\mathrm{.}5$

Female

$8$

$6$

$65$age$<7$

$6$

$705$lb$<90$

$2\mathrm{.}23$

$11$

Female

$7$

$7$

age$28$

$8$

Ib$290$

$2\mathrm{.}43$

$12$

Select one:

none of the other choices is correct

Lookup$\_$array $=1$$$3$:$L$$9,$ index $=4$

Lookup$\_$array $=1$$$3$:$L$$9,$ index $=3$

Lookup$\_$array $=$ H$$3$:$L$$9,$ index $=5$

Lookup$\_$array $=$ G$$3$:$L$$9,$ index $=6$