Lookup Question

Hi,

Apologies, this is related to my earlier post. I've created a new one as I couldn't see how to add a file when I edited the post. Hopefully this one is more clear too!

Sample source data is in columns A to C, and the lookup table is in columns G to I.

In the lookup table I’m trying to extract the value from column C that is associated with the product and country indicated in columns G and H.

The difficulty is how to deal with the blank in cell C6 as, in this example, a blank is not the same thing as a zero.

Can someone please suggest how I can amend the formulae in column I to accommodate the distinction between a blank cell and one containing the number zero.

Thanks very much!