How To "Strutt" Series

How to Insert a Multi-row Cross-reference    1/1, 1/3

This Strutt feature allows the user to insert a V-lookup on a range of data and easily change between them.

For example, assume that you have sound power spectra for a list of point sources (as shown in Figure 1) and you would like to compare the sound pressure levels at 15 m from the sources. You can use a multi-row cross-reference to quickly compare SPLs with only a single calculation.

Figure 1

Select any cell in the row in which you would like to insert the cross-reference, then select References > Insert Multi-Row Crossreference (Figure 2).

Figure 2

A window will pop up asking you to "Select multiple rows to reference as a lookup". Navigate to the sheet that contains the list of consecutive source sound powers and select the rows that you are interested in comparing (Figure 3).

Figure 3

When you click "OK", the sheet that contains the cross-reference row will reactivate. The first item in the list of sound powers will now be visible in the cross-reference row. If you click on the Item / Description cell of that row, a drop-down arrow becomes visible to the right hand side of the cell (Figure 4).

Figure 4

This arrow allows you to cycle through the list and to select a new source if you wish (Figure 5). The calculation will be automatically updated each time a new source is selected from the list.

Figure 5

That's all there is to it!

Note that the References menu also contains an Insert Single-Row Crossreference(s) option, which is useful in situations where you only want to create a reference to a single row.

Comments or suggestions to