chose the wrire answer

[muhammad Rafiq]

Hi everyone,

let me know about the correct formula and also explain it

given the table blow, which of the following formula should be entered in cell D2 to calculate the total cost of the group subscription based on monthly  cost  table?(select all the apply)

A	B	C	D	E	F	G	H
Serial no	Subscription type	No of subscription	Total cost p.month			Subscription type	COST P.MONTH
1	Monthly	100				monthly	10
2	Yearly	130				yearly	9
3	monthly	110				qualterly	6
4	yealy	50
5	quartly	20

1. Vlookup(B2,$G$1:$H$4,2)*C2
2. INDEX($H$2:$H$4,MACTH(B2,$G$2:$G$4,0))
3. C2*INDEX($H$2:$H$4,MACTH(B2,$G$2:$G$4,0)
4. VLOOKUP(B2,$G$1:$H$4,2)

[#2]

If you correct typos in some formulas and add multiplication on number of subscriptions where missed, you may use any of them