Need lookup formula to do partial lookup in one column and exact match in second col

For example in the item column (F4), I want to be able to type in 'Baked' and in the count column (G4), type 30. Then I want a formula in the Price column (H4) to lookup and return the Price for Baked Chip 30 CT.

Another example if I type in item Cereal Bar and count 48 return the price 9.82 for Quaker Cereal Bars 48 ct.

Then if it can also take abbreviations for what I type like if Item Hersh Alm, count 36 return the price 17.82 for Hershey Almond 36 ct.

I prefer it not to use any visual basic code as I will be running the program from my phone that doesn't support it.

Thanks in advance!

p.s. If partial lookup absolutely can't be done for item column then how to do exact match.

I've been working on it for a little while and i've come to a formula that works for exact lookup on each column: {=INDEX(C:C,MATCH(F4&G4,A:A&B:B,0))}

This works great, but like i said it only does the exact lookup for the item column. And it take a little while to calculate but I think I can speed that up by shortening ranges C:C, A:A, B:B etc....

Ran across another obstacle my phone won't recognize CTRL+SHIFT+ENTER array formulas which is not a big deal unless they can be avoided.

This is one tough cookie!