Any Lotus 123 guru's out there?
Discussion
I am working on a project to make some spreadsheets for a group of people who use Excel and Lotus 123, I have cracked the Excel spreadsheet (with many thanks to PistonHeads) but need to get the 123 spreadsheet to mirror the Excel one.
Now then I have 'Save As' the Excel one into 123 which has worked great except for 1 formula which uses the CHOOSE function. Does anyone know the 123 equivalent?
And guys, I've heard all the 123 jokes about scrapping it etc. it's just that some dyed-in-the-wool old dogs will never learn new tricks
Now then I have 'Save As' the Excel one into 123 which has worked great except for 1 formula which uses the CHOOSE function. Does anyone know the 123 equivalent?
And guys, I've heard all the 123 jokes about scrapping it etc. it's just that some dyed-in-the-wool old dogs will never learn new tricks
Thats a lookup function isnt it? I think in Lotus 1-2-3 its very similar, @choose.
Edited to say, yep, a quick google confirms it:
www.palmtoppaper.com/ptphtml/24/pt24002c.htm
(see bottom of page)
>> Edited by jam1et on Monday 29th March 17:00
Edited to say, yep, a quick google confirms it:
www.palmtoppaper.com/ptphtml/24/pt24002c.htm
(see bottom of page)
>> Edited by jam1et on Monday 29th March 17:00
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff