change an array

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
 
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))
 
Upvote 0
Solution

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top