Introduction

XLPicker is a lookup table popup add-in for Microsoft Excel which aims to extend or replace the existing List Data Validation.

That means that instead of this

Excel List Data Validation

you will get to work with this

XLPicker Lookup Table

XLPicker tries to keep it simple by depending on Excel named range or table as the source of the lookup.

Download

Download the XLPicker add-in by following the Download or Buy links on the Pricing page

XLPicker Pricing Page

All of the buttons will link to the checkout page where you can select the license type and quantity

XLPicker Checkout Page

For Trial Download, after clicking “Buy This” enter the licensee details then click “Get” to generate receipt for the download

XLPicker Trial Download Page

For Buy License, after clicking “Buy This” enter the licensee details then click “Pay” to generate receipt for the purchase

XLPicker Buy License Page

Email will be sent to the provided email with the license code

XLPicker Receipt

Click on “View Product” to go the Download page

XLPicker Email

After installation enter the provided license code in the email on the Activate dialog to activate the add-in

XLPicker Download Page

The commercial purchase of the add-in comes with 15 days money back guarantee

Installation

Download the installer from the Downloads link. Several installers will be provided:

  • Installer (.msi) for Excel 32 and 64-bit
  • Manual Install (.zip) for Excel 32-bit
  • Manual Install (.zip) for Excel 64-bit

The Windows Installer version will give the option to install XLPicker on a per-user or per-machine basis.

Installer Welcome Dialog

Installer License Dialog

Installer Option Dialog

Installer Finish Dialog

The per-machine option will require administrative access for the installing user.

Lookup Source

Will be shown only if

  • there is no List Data Validation configured for the current cell, or
  • there is more than one named range or table which the current cell is part of.

XLPicker Lookup Source

Filter tab

Name Description
Find What The text to filter the data table
Match Case Toggle the case sensitive match of the data table
Look At Toggle the Part/Whole match of the data table
Filter Filter the data being displayed in the table
Select This or double click on the row will set the source and open the lookup table dialog
Close Close the dialog without selecting any of the data

Lookup Table

XLPicker Filter Tab

Filter tab

Name Description
Find What The text to filter the data table
Match Case Toggle the case sensitive match of the data table
Look In Match with data table cell Values, Comments, Formulas, or Text
Look At Toggle the Part/Whole match of the data table
Filter Filter the data being displayed in the table

XLPicker Lookup Tab

Lookup tab

Name Description
Back To return back to the lookup source dialog
Stay Open Keep the dialog open after the data selection
Top Header Display row header as None, Table, Address, or Index
Left Header Display column header as None, Table, Address, or Index
Show As Display cell content as Text, Values, Comments, or Formulas
Value As Return the selected cell value as Value, Address, Lookup, Copy Only, or Copy Paste
Paste As Set the Excel paste option that will be used for the Value As = Copy Paste selection (see this or this for details)

For Top and Left Header:

  • None will display blank text
  • Table will display the header text
  • Address will display the header cell address
  • Index will display the header cell index

For Value As:

  • Value will return whatever value is there in the selected cell (Cell.Value2)
  • Address will return the cell address of the selected cell

    Value As Address Result

  • Lookup will return the index match formula of the selected cell

    Value As Lookup Match

    XLPicker Lookup Index

    XLPicker Lookup Result

  • Copy Only will just copy the value of the cell to clipboard (to preserve the undo stack)
  • CopY Paste (please see above note section)
Name Description
Paging To set the page size, page number, and navigate the pages
Select This or double click on the row will set the value and close the dialog
Close Close the dialog without selecting any of the data

Options

XLPicker Options


Name Description
Log Level The log level of the add-in execution (see Diagnostics Display or the add-in log file)
Cue Delay & Text The visual cue delay and text for the lookup selection (useful only for Stay Open mode)
VLookup Key The shortcut key to call the Vertical Lookup dialog (always prefix with ^ which means Ctrl+Shift)
HLookup Key The shortcut key to call the Horizontal Lookup dialog (always prefix with ^ which means Ctrl+Shift)
Theme The display theme of the add-in
Icon Color The icon color of the add-in
Theme Font The global font style of the add-in
Grid Fill The data table fill (background color)
Grid Color The data table color (font/foreground color)
Grid Font The data table font style
Display The read only grid to preview the options
Refresh Reload the options from the config file
Save Save the options to the config file
Close Close the options dialog

For Grid Fill, Color, and Font

  • Row is for the default row
  • Alternate is for the alternate row
  • Source is for the data validation list range (will only be available if the active cell has data validation list configured)
  • Selection is for the data table/grid selection

Log Display

This is the dialog that will be displayed automatically when there is an error with the add-in execution or if you just want to see the details of the add-in execution (when Log Level is set to lower than Warning).

Log/Diagnostic Display


Name Description
Save Save the current log to a text file
Copy Copy the current log to the clipboard
Clear Clear the log/diagnostic display logs

About

Displays the add-in info

About XLPicker


Name Description
Product The add-in name and version info
Copyright The add-in copyright information
License Type The license type for the add-in installation
Licensed To The licensee info for the add-in installation
Install Path The physical path in the file system where the add-in is installed
Setting Path The physical path in the file system where the add-in options is
Activate To activate the license by entering the license code provided in the email
Close The physical path in the file system where the add-in options is

Activate XLPicker