I am looking for a spreadsheet boffin! I would like the following Array Formula translated from Excel to work in Lotus 123.
Formual is =IF(OR(Entries!B2=RESULT),"WINS","")
RESULT is a range name and Entries is the name of the first worksheet.
This is to create a spreadsheet to run a Lottery Syndicate and appeared as a workshop in Computeractive magazine in May 1999!!
Anybody able to help. Thanks