Order Form Formula Fix Needed


#1

The purchased assets stuff in cell F112 has a VALUE! error that makes more work than necessasry. The formula is included below.

=sort({
{A7:B37};
{A123:B132};
filter(‘Black Market Prices’!B7:C471,‘Black Market Prices’!B7:B471 = F7);
filter(‘Black Market Prices’!B7:C471,‘Black Market Prices’!B7:B471 = F8);
filter(‘Black Market Prices’!B7:C471,‘Black Market Prices’!B7:B471 = F9);
filter(‘Black Market Prices’!B7:C471,‘Black Market Prices’!B7:B471 = F10);
filter(‘Black Market Prices’!B7:C471,‘Black Market Prices’!B7:B471 = F11);
filter(‘Black Market Prices’!B7:C471,‘Black Market Prices’!B7:B471 = F12);
filter(‘Black Market Prices’!B7:C471,‘Black Market Prices’!B7:B471 = F13);
filter(‘Black Market Prices’!B7:C471,‘Black Market Prices’!B7:B471 = F14);
filter(‘Black Market Prices’!B7:C471,‘Black Market Prices’!B7:B471 = F15);
filter(‘Black Market Prices’!B7:C471,‘Black Market Prices’!B7:B471 = F16);
filter(‘Black Market Prices’!B7:C471,‘Black Market Prices’!B7:B471 = F17);
filter(‘Black Market Prices’!B7:C471,‘Black Market Prices’!B7:B471 = F18);
filter(‘Black Market Prices’!B7:C471,‘Black Market Prices’!B7:B471 = F19);
filter(‘Black Market Prices’!B7:C471,‘Black Market Prices’!B7:B471 = F20);
filter(‘Black Market Prices’!B7:C471,‘Black Market Prices’!B7:B471 = F21);
filter(‘Black Market Prices’!B7:C471,‘Black Market Prices’!B7:B471 = F22);
filter(‘Black Market Prices’!B7:C471,‘Black Market Prices’!B7:B471 = F23);
filter(‘Black Market Prices’!B7:C471,‘Black Market Prices’!B7:B471 = F24);
filter(‘Black Market Prices’!B7:C471,‘Black Market Prices’!B7:B471 = F25);
filter(‘Black Market Prices’!B7:C471,‘Black Market Prices’!B7:B471 = F26)},1,true,2,true)