View Single Post
  #4   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 Sun, 11 Dec 2016 09:59:47 +0000 schrieb Dave1972:

Worked a treat...thank you. However...now I am intrigued....why didn't
the other formula work? any clue?


period is only one cell. Therefore MATCH doesn't work.
If you have a range named "period" you can use CHOOSE(MATCH...)
Have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgYM8Bn8SrF_p88VMVw
period is the named range R1:R4.


Regards
Claus B.
--
Windows10
Office 2016