>Yes but the VLOOKUP can use only one criteria... I need more.


Uhmm, tricky, no? OK, here is what I would do....

Dept(A) Class(B)     Title(C) Total(D)   .... SearchCol(x)
01      500 St.      Inv.-A   93960,00        <<formula here that concats the first three cols>>
01      500 St.      Cost-A   83234,00
01      500 St.      Curr-A   350101,00
01      500 Rec.     Qty      0,00 0,00
01      500 Rec.     Cost     0,00 0,00
01      500 Adj.     Qty      -3683,00
01      500 Adj.     Cost     -3273,00
01      500 Adj.     Curr     -15894,00 

VLOOKUP on X, returning the value in D