Double lookup/ matching?

Sorry I'm afraid this wasn't what I was after.

Here goes:

So my first table looks like this:

Col A heading = UIP, Col B Heading = LDZ, Col C heading = Quotes.

Then under the heading 'UIP' there are names such as British Gas, Eon, UU, etc.
Under the heading 'LDZ' there are entries such as EA, EM, WN, SC, etc.
Under the heading 'Quotes' there are simply number entries.

British Gas may appear several times in the table, as will Eon etc, but the combination 'British Gas' then 'EA' will only appear once. As this will be all the quotes for British gas in the EA area.
If there are no quotes though it will not have a 0 row, it just simply won't be in this table.

Now table 2 (I one I'm trying to produce) will look like this.

Cell A2 = British Gas
A3 = Eon
A4 = Edf
Etc

Cell B1 = EA
C1 = EM
D1 = SC
etc

Now in the middle of that table I need a formula to pull the correct numbers through from table 1. And if it can't find a match i.e. British gas & EA on the same row then it will either show zero or 'N/A', '#REF!'.

Hopefully I've explained it better than my lazy explanation y'day.

Thanks for your help,

Mark

P.s. I couldn't work out if I was able to attach a worksheet to send to you.