Skip to content
REFERENCE

U.GRID_LOOKUP

Summary

Returns intersection points of specified rows and columns

Syntax

=U.GRID_LOOKUP(row_labels, column_labels, data_range, [row_lookup_type], [column_lookup_type], [return_labels], [fail_values])

Parameters

Parameter Required Description
row_labels Yes The row or rows in the data range to be looked up. Set to "replace([num_row_labels],[num_col_labels],[ignore_blanks],[ignore_errors])" for replace logic. If "types" provided and no other params set, then a report of available lookup types is returned
column_labels Yes The column or columns in the data range to be looked up. Set to the full report that will have cells replaced when using replace logic
data_range Yes The data on which the row and column lookups will be performed. If only a valid topic is provided, the first page of that report will be used
[row_lookup_type] No Optional lookup type value to indicate the match logic to be applied to row labels. See table of valid values with descriptions in examples to the left
[column_lookup_type] No Optional lookup type value to indicate the match logic to be applied to column labels. See table of valid values with descriptions in examples to the left
[return_labels] No If set to TRUE then row and column labels are included in the result. Default is TRUE when replace logic invoked
[fail_values] No If set then specified value will be returned for failed lookups. By default an #N/A error is returned for failed lookups

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.

Examples

=U.GRID_LOOKUP(O304,P304,B303:H308)

=U.GRID_LOOKUP(K311:K312,L310:M310,B303:H308,,1)

=U.GRID_LOOKUP(K322:L323,M320:N321,B317:I324,S322:T323,P322:Q323)

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.