Does anyone know if it is possible to do combination searches with or without
ASAP utilities in Excel.

For example, I have one column that is postal codes (V2X 3T7), and one that
is names (Jack). I'm looking for a function that will allow me to search
multiple sheets/tabs for Jack and V2X. Something like Jack*V2X that will give
me all the "Jacks" with that postal prefix.

Any suggestions? So far I have only been able to search these separately.

Any help would be great!