Lookup multiple items

V

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.
 
X

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,
 
V

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
 
X

xlmate

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top