[Claus Busch]

Hi Dave,

Am Sat, 10 Dec 2016 09:55:38 +0000 schrieb Dave1972:

=A2*(CHOOSE(INDEX(MATCH(B2,period,0),1),52,26,12,2 ))

try:
=A2*VLOOKUP(period,{"week",52;"fortnight",26;"mont h",12;"bi-annual",2},2,0)


Regards
Claus B.
--
Windows10
Office 2016