Thanks Eric but i cant seem to get that to work? What do i have to replace
the '--' with?

What im trying to do is pick the amounts out from the list of codes and cost
centres i have, so i have the list of codes and cost centres here but with no
values yet, i need to be able to look into the download and pick out the
relevant amount relating to that specific code AND cost centre?

so something like =vlookup("0020" and "RIC", Array, 3)?!

Thanks
Tom.

"EricBB" wrote:

=SUMPRODUCT(--(a2:a3="0020"),--(b2:b3="RIC"),c2:c3)

"Bazy2k" wrote:

Hi guys

I have a list of data, 3 columns. Eg.

Code CostCentre Amount
0020 RIC 200.00
0020 LPM 350.00

As you can see the two items have the same code (0020) but different
CostCentre codes (RIC, LPM).
I want to be able to use vlookup (or any other means) to look for data which
has a code or 0020 AND a costcentre of RIC (or LPM). Problem obv with vlookup
is it only looks at the left-most side of data. How can i add an AND
statement to it so it can look up both pieces of data and gives me a result?

Thanks for your time.
Tom.