OCQ Lookup – Key Values


The name of the key field. There will be one row for each field in the primary key for the table.

Cell Reference

Check this box to make the target value come from a cell address in Excel.  Leave this box unchecked to hard code the value to what you type in the Value column.


If Cell Reference is checked, then enter the cell address here, otherwise; enter the actual value required to locate the desired record.


Click Cancel to dismiss the dialog without inserting the function.


Click Back to go back to the previous screen.


Click Next to advance to the next screen.


The Finish button is disabled until the wizard has sufficient information to insert the function.


Click Help to display the web help for the associated screen.