pboltonchina
Well-known Member
- Joined
- Apr 24, 2008
- Messages
- 1,124
Hello everyone, long time since I've been here but last time a gentleman gave me a perfect solution to my problem and it worked great.
I have just cancelled my Office 365 subscription and purchased Office 2019 Professional Plus (genuine) and installed it. The problem is that all the formulas my sheet uses, and were adaptable as my validation list changed are now Arrays that I can't edit. This is the fomula
=_xlfn.XLOOKUP(_xlfn._xlws.FILTER('Meals 2'!$B$2:$D$998,'Meals 2'!$A$2:$A$998=record!B22),'Meals list'!$A$1:$A$1113,'Meals list'!$B$1:$B$1113)
but it now has 2 wavy brackets around it { }. my sheet is now useless unless I get a solution.
As always any help is greatly appreciated. Regards
Paul
I have just cancelled my Office 365 subscription and purchased Office 2019 Professional Plus (genuine) and installed it. The problem is that all the formulas my sheet uses, and were adaptable as my validation list changed are now Arrays that I can't edit. This is the fomula
=_xlfn.XLOOKUP(_xlfn._xlws.FILTER('Meals 2'!$B$2:$D$998,'Meals 2'!$A$2:$A$998=record!B22),'Meals list'!$A$1:$A$1113,'Meals list'!$B$1:$B$1113)
but it now has 2 wavy brackets around it { }. my sheet is now useless unless I get a solution.
As always any help is greatly appreciated. Regards
Paul