View Single Post
  #3   Report Post  
Dave1972 Dave1972 is offline
Junior Member
 
Posts: 3
Default

Quote:
Originally Posted by Claus Busch View Post
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
Hey there Claus,
Worked a treat...thank you. However...now I am intrigued....why didn't the other formula work? any clue?