Hi all,
Once again thanks for the previous help this forum rendered. Struck with
another problem Help me please.

My problem is , I have 4 sheets by name a, b, c & d In the 5th sheet i need
to lookup all the related values from each sheet and should paste one after
another. Note: My lookup value is may also repeats (may be 100 times).
Tried VLookup but in vain. In other words...
sheet 5 has got as follows:
col1 col2 col3
quote1 product1 Inv Date1
quote2 Product2 Inv Date2
quote3 product1 inv date1
quote1 product2 inv date1

what i am looking is as follows:

col1 col2 col3
quote1 product1 Inv Date1
quote1 product2 inv date1
quote2 Product2 Inv Date2
quote3 product1 inv date1

Hope i asked properly.