OCQ Lookup – Key Values

Field

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.

Value

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

Cancel

Click Cancel to dismiss the dialog without inserting the function.

Back

Click Back to go back to the previous screen.

Next

Click Next to advance to the next screen.

Finish

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

Help

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