3D model association in PCB Design - Cell-by-Cell Formula Trace

Sample Data

This table lists PCB components and their associated 3D model files used for visualization in PCB design software.

Cell	Value
A1	Component
B1	3D Model File
A2	Resistor R1
B2	resistor_3d.step
A3	Capacitor C1
B3	capacitor_3d.step
A4	IC U1
B4	ic_3d.step

Formula Trace

LOOKUPVALUE('3D Models'[ModelFile], '3D Models'[Component], 'PCB Components'[Component])

Step 1: LOOKUPVALUE('3D Models'[ModelFile], '3D Models'[Component], "Resistor R1")

Step 2: LOOKUPVALUE('3D Models'[ModelFile], '3D Models'[Component], "Capacitor C1")

Step 3: LOOKUPVALUE('3D Models'[ModelFile], '3D Models'[Component], "IC U1")

Cell Reference Map

   A           B
1 Component   3D Model File
2 Resistor R1 resistor_3d.step
3 Capacitor C1 capacitor_3d.step
4 IC U1       ic_3d.step

Formula references the Component column to find matching 3D Model File.

The formula uses the Component names in column A to find the matching 3D Model File in column B.

Result

   A           B
1 Component   3D Model File
2 Resistor R1 resistor_3d.step
3 Capacitor C1 capacitor_3d.step
4 IC U1       ic_3d.step

The result shows each component linked to its 3D model file for visualization.

The final output associates each PCB component with its correct 3D model file, enabling 3D visualization in the PCB design tool.

Sheet Trace Quiz - 3 Questions

What does the formula LOOKUPVALUE return for 'Resistor R1'?

A capacitor_3d.step

B resistor_3d.step

C ic_3d.step

D No value

Key Result

LOOKUPVALUE returns a value from one column by matching a key in another column.