hi guys
thanks to nbvc i have this formula
=SUMPRODUCT(--('head to head'!D:D='input sheet'!G1),--('head to head'!H:H='input sheet'!G1))
but the trouble is i need it to understand there may be wildcards

ie

input sheet g1 has the word "york" in it ( without the quotes )

however the results in columns d and h
may suggest "york city"