| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup multiple items
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup multiple items
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup multiple items
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup multiple items
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup multiple items
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup multiple items
|
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup multiple items
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup value with items in different rows | Excel Worksheet Functions | |||
| Lookup match 2 items | New Users to Excel | |||
| Lookup items and have picture appear together. | Excel Worksheet Functions | |||
| order form with multiple items and sizes for items | Excel Discussion (Misc queries) | |||
| Sum items in a lookup table. | Excel Discussion (Misc queries) | |||
![Vijay DSK[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
