Dynamic Excel functions can make lookup systems more flexible.

XLOOKUP Example

=XLOOKUP(H2,A2:A100,F2:F100,”Not Found”)

Dynamic Lookup with FILTER

Find all orders for a selected city:

=FILTER(A2:H100,D2:D100=H2,”No Records”)

Dynamic Lookup with UNIQUE

Create a dynamic selection list:

=UNIQUE(D2:D100)

Then use the selected city in a FILTER formula.

Dynamic Lookup Workflow

Select City → Dynamic Criteria → FILTER → Automatically Updated Report

Practice

Create a customer lookup system where selecting a customer automatically displays all matching sales records.