Another solution would be to add a helper column in front of your 'code'
column. Then concatenate the code and cost center together (e.g., 0020RIC)
using a formula. copy/paste the formula in front of all your data. Then do
the vlookup on the concatenation.


"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.