Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to Find a Value in Sheet (using VBA) ?
Message
Information générale
Forum:
Microsoft Office
Catégorie:
Excel
Divers
Thread ID:
01096153
Message ID:
01096250
Vues:
15
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform