Sign Up for Training |
Jet Global Company Site
Community
Downloads
Submit a Request
Give Feedback

Conditional Replication


Overview

You cannot wrap any replicating NL function (Rows, Columns, Sheets) inside of an Excel IF() function.  Replicating functions must stand alone in a cell.

To make conditional replication work we simply place our IF() function in the Table argument of the replicator and return either the name of the table for which we want to replicate values or an array with one blank value.

This means the replicator will either query a table and replicate its values or return a single blank. 

Example

If we wish to list names from the customer table if cell B3=42 our function would look like this:

=NL("Rows",IF($B$3=42,"Customer",{""}),"Name") 

 

If you put an array in the "Table" argument of a replicator it will replicate the values in the array.  So, NL("Rows",{1,2,3}) will return the values 1, 2, 3 in rows.
Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments