Is it possible to type a value in a cell that would then be referenced by a
field in a pivot table and then lookup and select that value instead of using
the drop down box and having to search through the entire list to find the
value necessary. Thanks.