About Us

xlmate

sorry, typo.

send it to

"Vijay DSK" wrote:

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

"xlmate" wrote:

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

"Vijay DSK" wrote:

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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Lookup value with items in different rows	clubin	Excel Worksheet Functions	5	November 13th 08 10:22 PM
Lookup match 2 items	HFC-SC	New Users to Excel	4	August 17th 06 07:58 AM
Lookup items and have picture appear together.	WL	Excel Worksheet Functions	6	March 14th 06 03:32 PM
order form with multiple items and sizes for items	Bernard56	Excel Discussion (Misc queries)	1	January 17th 06 11:43 PM
Sum items in a lookup table.	JICDB	Excel Discussion (Misc queries)	2	December 30th 05 02:13 PM