View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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