Excel Function

There's tab called US, MX, CL and in each tab cell locations are all the same (different data set)

1. (B6=US!C2:C)*(C6=US!D2:D) these two are must but (D6=US!E2:E) is an option

2. I'm getting error and I don't know why

=ArrayFormula(IFERROR(INDEX(US!A2:L,MATCH(1,(B6=US!C2:C)*(C6=US!D2:D)*(D6=US!E2:E),0),11),"N/A"))+

ArrayFormula(IFERROR(INDEX(MX!A2:L,MATCH(1,(B6=MX!C2:C)*(C6=MX!D2:D)*(D6=MX!E2:E),0),11),"N/A"))+

ArrayFormula(IFERROR(INDEX(CL!A2:L,MATCH(1,(B6=CL!C2:C)*(C6=CL!D2:D)*(D6=CL!E2:E),0),11),"N/A"))

Below are the tabs

US MX CL Tabs are looks like below

Below is the Search Box in Search Tab

Search Tab Bulk Search Tab US MX, CL Reference Country = Vehicle Name = Vehicle Model 1 2 US US 3.2 CL 3.2 Diesel a 8.1 8.1 US US 8.1 19 US 20 US = Vehicle Year = Vehicle Maker 1980 ACURA 1999 ACURA 1999 ACURA 2000 ACURA 2011 AUDI 1999 BLUE BIRD 1999 BLUE BIRD 2000 BLUE BIRD 2000 BLUE BIRD 2000 BLUE BIRD 2000 BLUE BIRD 2000 BLUE BIRD 2000 BLUE BIRD 2000 BLUE BIRD 2000 BLUE BIRD 2000 BLUE BIRD 2000 BLUE BIRD 2001 BLUE BIRD 2001 BLUE BIRD 2001 BLUE BIRD 2003 BLUE BIRD 2003 BLUE BIRD 2003 BLUE BIRD 2003 BLUE BIRD 2003 BLUE BIRD 2003 BLUE BIRD 2003 BLUE BIRD 2003 BLUE BIRD 2003 BLUE BIRD 2011 BLUE BIRD 2011 BLUE BIRD 2013 BLUE BIRD 2014 BLUE BIRD BLUE BIRD 2014 BLUE BIRD 2014 BLUE BIRD 2012 BMW 2015 BMW 1999 BUICK 2011 BUICK 2013 BUICK 1999-Acura-CL 1999-Acura-CL 2000-Acura-TL 2011-Audi-A4 Quatro 1999-Blue Bird-TC2000 1999-Blue Bird-TC2000 2000-Blue Bird-All American 2000-Blue Bird-All American 2000-Blue Bird-All American 2000-Blue Bird-All American 2000-Blue Bird-All American 2000-Blue Bird-All American/All Canadian 2000-Blue Bird-All American/All Canadian 2000-Blue Bird-All American 2000-Blue Bird-All American 2000-Blue Bird-All American/All Canadian 2001-Blue Bird-Blue Bird 2001-Blue Bird-All American/All Canadian 2001-Blue Bird-All American/All Canadian 2003-Blue Bird-All American 2003-Blue Bird-All American 2003-Blue Bird-All American 2003-Blue Bird-All American/All Canadian 2003-Blue Bird-All American/All Canadian 2003-Blue Bird-All American/All Canadian 2003-Blue Bird-All American/All Canadian 2003-Blue Bird-All American/All Canadian 2003-Blue Bird-All American 2011-Blue Bird-Vision 2011-Blue Bird-Vision 2013-Blue Bird-All American 2014-Blue Bird-All American 2014-Blue Bird-All American 2014-Blue Bird-All American 2014-Blue Bird-All American 2012-BMW-128i 2015-BMW-LX 1999-Buick-Century 2011-BUICK LUCERNE-SAND BEIGE 2013-BUICK LACROSSE-QUICKSILVER = Vehicle Capacity = Fuel Type = Protocol = Work Mode = |VIN 2.2 Gas CAN11 Passenger Car Gas ISO9141 Passenger Car 19UYA3156XL003510 Gas CAN11 Passenger Car Gas ISO9141 Passenger Car 19UYA4244A113600 Gas UNKNOWN Passenger Car Wrong VIN 8.1 UNKNOWN Tracker 1BAANB7A7XF085310 8.1 Diesel a UNKNOWN Tracker 213GL2015012070 Diesel a UNKNOWN Tracker 1BABNBMA2YF092532 Diesel a UNKNOWN Tracker 1 BABNBMASYF092542 8.1 Diesel a UNKNOWN Tracker 1BABNBMA6YF092534 8.1 Diesel a UNKNOWN Tracker 1 BABNBMASYF095539 8.1 Diesel a UNKNOWN Tracker 1 BABNBMA3YF092538 8.1 Diesel a UNKNOWN Tracker 1 BABNBMA7YF092543 8.1 Diesel a UNKNOWN Tracker 1 BABNBMA3YF092541 Diesel a UNKNOWN Tracker 1 BABNBMA4YF092533 Diesel a UNKNOWN Tracker 1 BABNBMA2YF092532 8.1 Diesel a UNKNOWN Tracker 1BABNBMA1YF092537 8.1 Hybrid UNKNOWN Tracker 1BABNBMAX17099380 8.1 Diesel a UNKNOWN Tracker 1 BABNBMA11F099381 8.1 Diesel a UNKNOWN Tracker 1 BABNBMA31F099379 Diesel a UNKNOWN Tracker 1 BABNBMA63F207688 Diesel a UNKNOWN Tracker 1 BABNBMA73F207683 8.1 Diesel a UNKNOWN Tracker 1 BABNBMA63F207691 8.1 Diesel a UNKNOWN Tracker 1 BABNBMA43F207690 Diesel a UNKNOWN Tracker 1 BABNBMA43F207687 8.1 Diesel a UNKNOWN Tracker 1BABNBMA83F207689 8.1 Diesel a UNKNOWN Tracker 1 BABNBMA03F207685 Diesel a UNKNOWN Tracker 1 BABNBMA23F207686 Diesel a UNKNOWN Tracker 1 BABNBMA93F207684 6.7 Diesel a J1939 Heavy Duty 1BAKCCPH3BF281475 Diesel a J1939 Heavy Duty 1BAKCCPA2BF282328 8.1 Diesel a UNKNOWN Tracker 1GDJG311661168744 Diesel a UNKNOWN Tracker 1 BABGBAA5EF299197 Diesel a UNKNOWN Tracker 1BABGBAA1EF299195 8.1 Diesel a UNKNOWN Tracker 1BABGBAA3EF299196 Diesel a UNKNOWN Tracker 1BABNBAA2EF299194 Gas VPW Passenger Car WBAUP9C50CVL91034 CAN11 Passenger Car 3.1 Gas VPW Passenger Car Gas CAN11 Passenger Car 1G4HC5EM7BU149693 Gas CAN11 Passenger Car 1G4GH5E30DF243412 22 US 23 US 24 US = Diagnostic Connector = FleetUp Cable Name = OBDII (16-pin) 16FSB OBDII (16-pin) 16FSB OBDII (16-pin) 16FSB OBDII (16-pin) 16FSB OBDII (16-pin) 16FSB Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable 9-pin 9FSB 9-pin 9FSB Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable OBDII (16-pin) 16FSB OBDII (16-pin) 16FSB OBDII (16-pin) 16FSB OBDII (16-pin) 16FSB OBDII (16-pin) 16FSB TL A4 QUATRO TC2000 TC2000 ALL AMERICAN ALL AMERICAN ALL AMERICAN ALL AMERICAN ALL AMERICAN ALL AMERICAN/ALL CANADIAN ALL AMERICAN/ALL CANADIAN ALL AMERICAN ALL AMERICAN ALL AMERICAN/ALL CANADIAN BLUE BIRD ALL AMERICAN/ALL CANADIAN ALL AMERICAN/ALL CANADIAN ALL AMERICAN ALL AMERICAN ALL AMERICAN ALL AMERICAN/ALL CANADIAN ALL AMERICAN/ALL CANADIAN ALL AMERICAN/ALL CANADIAN ALL AMERICAN/ALL CANADIAN ALL AMERICAN/ALL CANADIAN ALL AMERICAN VISION VISION ALL AMERICAN ALL AMERICAN ALL AMERICAN ALL AMERICAN ALL AMERICAN 1281 LX CENTURY SAND BEIGE QUICKSILVER 8.1 8.1 8.1 8.1 8.1 30 31 32 33 US US US US & 1 US 2014 8.1 36 37 38 39 40 41 42 US US US Us US US US 39 3.6 Vehicle Year Vehicle Make Vehicle Model Diagnostic Connector Recommended Cable 2014 Blue Bird All American #VALUE! Power Cable Search Tab Bulk Search Tab US MX, CL Reference Country = Vehicle Name = Vehicle Model 1 2 US US 3.2 CL 3.2 Diesel a 8.1 8.1 US US 8.1 19 US 20 US = Vehicle Year = Vehicle Maker 1980 ACURA 1999 ACURA 1999 ACURA 2000 ACURA 2011 AUDI 1999 BLUE BIRD 1999 BLUE BIRD 2000 BLUE BIRD 2000 BLUE BIRD 2000 BLUE BIRD 2000 BLUE BIRD 2000 BLUE BIRD 2000 BLUE BIRD 2000 BLUE BIRD 2000 BLUE BIRD 2000 BLUE BIRD 2000 BLUE BIRD 2001 BLUE BIRD 2001 BLUE BIRD 2001 BLUE BIRD 2003 BLUE BIRD 2003 BLUE BIRD 2003 BLUE BIRD 2003 BLUE BIRD 2003 BLUE BIRD 2003 BLUE BIRD 2003 BLUE BIRD 2003 BLUE BIRD 2003 BLUE BIRD 2011 BLUE BIRD 2011 BLUE BIRD 2013 BLUE BIRD 2014 BLUE BIRD BLUE BIRD 2014 BLUE BIRD 2014 BLUE BIRD 2012 BMW 2015 BMW 1999 BUICK 2011 BUICK 2013 BUICK 1999-Acura-CL 1999-Acura-CL 2000-Acura-TL 2011-Audi-A4 Quatro 1999-Blue Bird-TC2000 1999-Blue Bird-TC2000 2000-Blue Bird-All American 2000-Blue Bird-All American 2000-Blue Bird-All American 2000-Blue Bird-All American 2000-Blue Bird-All American 2000-Blue Bird-All American/All Canadian 2000-Blue Bird-All American/All Canadian 2000-Blue Bird-All American 2000-Blue Bird-All American 2000-Blue Bird-All American/All Canadian 2001-Blue Bird-Blue Bird 2001-Blue Bird-All American/All Canadian 2001-Blue Bird-All American/All Canadian 2003-Blue Bird-All American 2003-Blue Bird-All American 2003-Blue Bird-All American 2003-Blue Bird-All American/All Canadian 2003-Blue Bird-All American/All Canadian 2003-Blue Bird-All American/All Canadian 2003-Blue Bird-All American/All Canadian 2003-Blue Bird-All American/All Canadian 2003-Blue Bird-All American 2011-Blue Bird-Vision 2011-Blue Bird-Vision 2013-Blue Bird-All American 2014-Blue Bird-All American 2014-Blue Bird-All American 2014-Blue Bird-All American 2014-Blue Bird-All American 2012-BMW-128i 2015-BMW-LX 1999-Buick-Century 2011-BUICK LUCERNE-SAND BEIGE 2013-BUICK LACROSSE-QUICKSILVER = Vehicle Capacity = Fuel Type = Protocol = Work Mode = |VIN 2.2 Gas CAN11 Passenger Car Gas ISO9141 Passenger Car 19UYA3156XL003510 Gas CAN11 Passenger Car Gas ISO9141 Passenger Car 19UYA4244A113600 Gas UNKNOWN Passenger Car Wrong VIN 8.1 UNKNOWN Tracker 1BAANB7A7XF085310 8.1 Diesel a UNKNOWN Tracker 213GL2015012070 Diesel a UNKNOWN Tracker 1BABNBMA2YF092532 Diesel a UNKNOWN Tracker 1 BABNBMASYF092542 8.1 Diesel a UNKNOWN Tracker 1BABNBMA6YF092534 8.1 Diesel a UNKNOWN Tracker 1 BABNBMASYF095539 8.1 Diesel a UNKNOWN Tracker 1 BABNBMA3YF092538 8.1 Diesel a UNKNOWN Tracker 1 BABNBMA7YF092543 8.1 Diesel a UNKNOWN Tracker 1 BABNBMA3YF092541 Diesel a UNKNOWN Tracker 1 BABNBMA4YF092533 Diesel a UNKNOWN Tracker 1 BABNBMA2YF092532 8.1 Diesel a UNKNOWN Tracker 1BABNBMA1YF092537 8.1 Hybrid UNKNOWN Tracker 1BABNBMAX17099380 8.1 Diesel a UNKNOWN Tracker 1 BABNBMA11F099381 8.1 Diesel a UNKNOWN Tracker 1 BABNBMA31F099379 Diesel a UNKNOWN Tracker 1 BABNBMA63F207688 Diesel a UNKNOWN Tracker 1 BABNBMA73F207683 8.1 Diesel a UNKNOWN Tracker 1 BABNBMA63F207691 8.1 Diesel a UNKNOWN Tracker 1 BABNBMA43F207690 Diesel a UNKNOWN Tracker 1 BABNBMA43F207687 8.1 Diesel a UNKNOWN Tracker 1BABNBMA83F207689 8.1 Diesel a UNKNOWN Tracker 1 BABNBMA03F207685 Diesel a UNKNOWN Tracker 1 BABNBMA23F207686 Diesel a UNKNOWN Tracker 1 BABNBMA93F207684 6.7 Diesel a J1939 Heavy Duty 1BAKCCPH3BF281475 Diesel a J1939 Heavy Duty 1BAKCCPA2BF282328 8.1 Diesel a UNKNOWN Tracker 1GDJG311661168744 Diesel a UNKNOWN Tracker 1 BABGBAA5EF299197 Diesel a UNKNOWN Tracker 1BABGBAA1EF299195 8.1 Diesel a UNKNOWN Tracker 1BABGBAA3EF299196 Diesel a UNKNOWN Tracker 1BABNBAA2EF299194 Gas VPW Passenger Car WBAUP9C50CVL91034 CAN11 Passenger Car 3.1 Gas VPW Passenger Car Gas CAN11 Passenger Car 1G4HC5EM7BU149693 Gas CAN11 Passenger Car 1G4GH5E30DF243412 22 US 23 US 24 US = Diagnostic Connector = FleetUp Cable Name = OBDII (16-pin) 16FSB OBDII (16-pin) 16FSB OBDII (16-pin) 16FSB OBDII (16-pin) 16FSB OBDII (16-pin) 16FSB Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable 9-pin 9FSB 9-pin 9FSB Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable Power Wire Power Cable OBDII (16-pin) 16FSB OBDII (16-pin) 16FSB OBDII (16-pin) 16FSB OBDII (16-pin) 16FSB OBDII (16-pin) 16FSB TL A4 QUATRO TC2000 TC2000 ALL AMERICAN ALL AMERICAN ALL AMERICAN ALL AMERICAN ALL AMERICAN ALL AMERICAN/ALL CANADIAN ALL AMERICAN/ALL CANADIAN ALL AMERICAN ALL AMERICAN ALL AMERICAN/ALL CANADIAN BLUE BIRD ALL AMERICAN/ALL CANADIAN ALL AMERICAN/ALL CANADIAN ALL AMERICAN ALL AMERICAN ALL AMERICAN ALL AMERICAN/ALL CANADIAN ALL AMERICAN/ALL CANADIAN ALL AMERICAN/ALL CANADIAN ALL AMERICAN/ALL CANADIAN ALL AMERICAN/ALL CANADIAN ALL AMERICAN VISION VISION ALL AMERICAN ALL AMERICAN ALL AMERICAN ALL AMERICAN ALL AMERICAN 1281 LX CENTURY SAND BEIGE QUICKSILVER 8.1 8.1 8.1 8.1 8.1 30 31 32 33 US US US US & 1 US 2014 8.1 36 37 38 39 40 41 42 US US US Us US US US 39 3.6 Vehicle Year Vehicle Make Vehicle Model Diagnostic Connector Recommended Cable 2014 Blue Bird All American #VALUE! Power Cable