Spreadsheet: 848088d1698880384-indirect-formula-to-place-images-vehicle-class-indirect-formula-004
Sheet: IMAGE PLACEMENT FORMULA

 | Key | Named [NAME] (The named ranges will be altered in thee final workbook) | Cell Values (The text in each cell will be altered in the final workbook) | Display the correct image in Cell E3 using an INDIRECT formula | Image to be placed in Cell E3 | The formula is based on the following criteria:
 | #[NAME]! | A_KEY | Alpha |  |  | IF Cell D3 is = to the text "Alpha" then display the A Key image in Cell B3 in Cell E3 |  |  |  | A | Motorcycles - 2 axles - 3 tires
 | #[NAME]! | [NAME] | Bravo |  |  | IF Cell D3 is = to the text "Bravo" then display the B Key image in Cell B4 in Cell E3 |  |  |  | B | Passenger Cars - 2 axles - can have 1 or 2 axle trailers
 | #[NAME]! | C_KEY | [NAME] |  |  | IF Cell D3 is = to the text "Charlie" then display the B Key image in Cell B5 in Cell E3 |  |  |  | C | Pickups, Panels, Vans - 2 axles - 4-tire single units - Can have 1 or 2 axle trailers
 | #[NAME]! | D_KEY | Delta |  |  | IF Cell D3 is = to the text "Delta" then display the B Key image in Cell B6 in Cell E3 |  |  |  | D | Buses - 2 or 3 axles - full length
 | #[NAME]! | E_KEY | Echo |  |  | IF Cell D3 is = to the text "Echo" then display the E Key image in Cell B7 in Cell E3 |  |  |  | E | Single Unit 2-axle Trucks - 2 axles - 6 tires (dual rear tires - single unit)
 | #[NAME]! | F_KEY | Foxtrot |  |  | IF Cell D3 is = to the text "Foxtrot" then display the F Key image in Cell B8 in Cell E3 |  |  |  | F | Single Unit 3-axle Trucks - 3 axles - single unit
 | #[NAME]! | G_KEY | Gulf |  |  | IF Cell D3 is = to the text "Gulf" then display the G Key image in Cell B9 in Cell E3 |  |  |  | G | Single Unit 4 or More-axle Trucks - 4 or more axles - single unit
 | #[NAME]! | H_KEY | Hotel |  |  | IF Cell D3 is = to the text "Hotel" then display the H Key image in Cell B10 in Cell E3 |  |  |  | H | Single Trailer 3 or 4 axle Trucks - 3 or 4 axles - single trailer
 | #[NAME]! | I_KEY | India |  |  | IF Cell D3 is = to the text "India" then display the I Key image in Cell B11 in Cell E3 |  |  |  | I | Single Trailer 5 axle trucks - 5 axles - single trailer
 | #[NAME]! | J_KEY | [NAME] |  |  | IF Cell D3 is = to the text "[NAME]" then display the J Key image in Cell B12 in Cell E3 |  |  |  | J | Single Trailer 6 or More axle Trucks - 6 or more axles - single trailer
 | #[NAME]! | [NAME] | Kilo |  |  | IF Cell D3 is = to the text "Kilo" then display the K Key image in Cell B13 in Cell E3 |  |  |  | K | Multi-Trailer 5 or Less-axle Trucks - 5 or less axles - multiple trailers
 | #[NAME]! | L_KEY | Lima |  |  | IF Cell D3 is = to the text "Lima" then display the L Key image in Cell B14 in Cell E3 |  |  |  | L | Multi-Trailer 6 axle trucks - 6 axles - multiple trailers
 | #[NAME]! | [NAME] | Mic |  |  | IF Cell D3 is = to the text "Mic" then display the M Key image in Cell B15 in Cell E3 |  |  |  | M | Multi-Trailer 7 or More-axle Trucks - 7 or more axles - multiple trailers
 | #[NAME]! | N_KEY | November |  |  | IF Cell D3 is = to the text "November" then display the N Key image in Cell B16 in Cell E3 |  |  |  | N | Pedal Bike - Pedal bikes are categorized as Bicycle on Road.