Marc,
Take a look at the vlookup function in excell.... It should be able to do what you need.
>I am in a workbook and I need to open another workbook to get a particular value in a sheet. Before to read this value, I have to find it with some criteria. In the following sample, if the Dept is "01" and Class is "500" and Title is "St. Curr-A", then the value I need is 350101,00 (located in column E). How can I find that value in VBA code? Thank you!
>
>Dept(A) Class(B)Title(C) Total(D) Month 01(E)
>01 500 St. Inv.-A 93960,00
>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 Rec.Cur. 0,00 0,00
>01 500 Adj.Qty -3683,00 -3683,00
>01 500 Adj.Cost -3273,00 -3273,00
>01 500 Adj.Curr -15894,00 -15894,00
Ricardo A. Parodi
eSolar, Inc.