Choose function not working
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
|