VLOOK UP

[kalpesh]

Hello, is any body have idea about my problem describe below???

sheet

A Col B Col C Col D Co
Bill no Item Qut Rat

501 Bat 10 22
501 Hocky 20 27
501 T T Bat 30 25
502 Football 10 27
502 VollyBall 25 30
502 Carrom 5 40

No

Sheet 2 in E1 Cell i enter Bill No 50

Result Shown a
A2 col B2 Col C2 Co
Item Qut Rat
Bat 10 22
Hocky 20 27
T T Bat 30 25


O

Sheet 2 in E5 Cell i enter Bill no 50

Result Shown A

A2 col B2 Col C2 Co
Item Qut Rat
Football 10 27
Vollyball 25 30
Carrom 5 40


How work it with Vlookup function Or Vba Code

 

[Don Guillett]

Hello, is any body have idea about my problem describe below????

 sheet 1

 A Col  B Col      C Col        D Col
 Bill no        Item       Qut   Rate

 501           Bat              10       225
 501            Hocky   20       275
 501           T T Bat  30      250
 502          Football  10      275
 502         VollyBall  25      300
 502          Carrom    5       400

 Now

 Sheet 2 in  E1 Cell i enter Bill No 501

 Result Shown as
 A2 col B2 Col  C2 Col
 Item            Qut    Rate
 Bat             10              225
 Hocky   20             275
 T T Bat        30               250

 Or

 Sheet 2 in E5 Cell i enter Bill no 502

 Result Shown As

 A2 col B2 Col  C2 Col
 Item             Qut   Rate
 Football         10           275
 Vollyball        25           300
 Carrom     5          400

 How work it with Vlookup function Or Vba Code

Why not just use data>filter>autofiter>filter on the number. Copy to
the other sheet if necessary. Record a macro>clean it up.