My apologies for not asking the question properly.

What I am looking is I need to bring all the data from other sheets basing
on a value in sheet 5. But this sheet 5 has got duplicate entries and there
are different values in other sheets. Hope I am clear

"xlmate" wrote:

I am not clear as to what you want to achieve. Let try,
are you saying that you have this on Sheet5?

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

and you want this result ?
col1 col2 col3
quote1 product1 Inv Date1
quote1 product2 inv date1
quote2 Product2 Inv Date2
quote3 product1 inv date1

If yes, you could just do a sort ascending from Menu bar
under Data Sort in the dialog box, select Column A
and check Ascending.
You need to adjust for header row here

Does this do what you want?
Pls click Yes if this have help you.

cheers,

"Vijay DSK" wrote:

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.