change an array

[pboltonchina]

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

 

[ebea]

By example you could have used Column D, and made an IF formula, to do the filter function.
Maybe a little change in the proposed formula could do it:
=INDEX('Meals list'!$B$1:$B$1113, MATCH(TRUE, INDEX('Meals 2'!$A$2:$A$998=record!B22, 0), 0))

 

[pboltonchina]

All sorted now thanks very much to all who replied