Lookup multiple items

[Vijay DSK]

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.

 

[xlmate]

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]

My apologies for not asking the question properly.

What I am looking is I need to bring all the data from other sheets basing

 

[xlmate]

would you provide the expected result you want and what the other sheets and
Sheet 5 layout look like

 

[Vijay DSK]

Hi,
I cant upload a file here will certainly do if you provide your email id

 

[xlmate]

(e-mail address removed)

Hi,
I cant upload a file here will certainly do if you provide your email id

 

[xlmate]

sorry, typo.

send it to (e-mail address removed)

Hi,
I cant upload a file here will certainly do if you provide your email id