| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup - multiple values
Is there any advanced function to vlookup to extract multiple data if the
required item is repeated in the data? Thank you Sridhar |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup - multiple values
Yes, but you need to give us some of details. Note that it's much simpler if
the data is sorted or grouped together: Tom...10 Sue...21 Tom...17 Lou...14 Sue...10 Easier to deal with if it's like this: Tom...10 Tom...17 Sue...21 Sue...10 Lou...14 -- Biff Microsoft Excel MVP "yshridhar" wrote in message ... Is there any advanced function to vlookup to extract multiple data if the required item is repeated in the data? Thank you Sridhar |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup - multiple values
Thank you Mr. T.Valko. But my data is not grouped. I have to update it
daily. Is there any procedure for unsorted data regards Sridhar "T. Valko" wrote: Yes, but you need to give us some of details. Note that it's much simpler if the data is sorted or grouped together: Tom...10 Sue...21 Tom...17 Lou...14 Sue...10 Easier to deal with if it's like this: Tom...10 Tom...17 Sue...21 Sue...10 Lou...14 -- Biff Microsoft Excel MVP "yshridhar" wrote in message ... Is there any advanced function to vlookup to extract multiple data if the required item is repeated in the data? Thank you Sridhar |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup - multiple values
At the bottom of the page at this link Nick Hodge explains how to query
Access data from Excel. You can very easily change this to query your Excel data so that when you change the entry in a cell it pulls in all the data related to that entry from your main list. http://www.nickhodge.co.uk/gui/datam...taexamples.htm "yshridhar" wrote: Thank you Mr. T.Valko. But my data is not grouped. I have to update it daily. Is there any procedure for unsorted data regards Sridhar "T. Valko" wrote: Yes, but you need to give us some of details. Note that it's much simpler if the data is sorted or grouped together: Tom...10 Sue...21 Tom...17 Lou...14 Sue...10 Easier to deal with if it's like this: Tom...10 Tom...17 Sue...21 Sue...10 Lou...14 -- Biff Microsoft Excel MVP "yshridhar" wrote in message ... Is there any advanced function to vlookup to extract multiple data if the required item is repeated in the data? Thank you Sridhar |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup - multiple values
Yes, but you still have to give us the details. Without knowing any of the
details I can't suggest anything. -- Biff Microsoft Excel MVP "yshridhar" wrote in message ... Thank you Mr. T.Valko. But my data is not grouped. I have to update it daily. Is there any procedure for unsorted data regards Sridhar "T. Valko" wrote: Yes, but you need to give us some of details. Note that it's much simpler if the data is sorted or grouped together: Tom...10 Sue...21 Tom...17 Lou...14 Sue...10 Easier to deal with if it's like this: Tom...10 Tom...17 Sue...21 Sue...10 Lou...14 -- Biff Microsoft Excel MVP "yshridhar" wrote in message ... Is there any advanced function to vlookup to extract multiple data if the required item is repeated in the data? Thank you Sridhar |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup - multiple values
Thank you Mr. T. Valko. Can i send my data file. How to email it to you?
Sridhar "T. Valko" wrote: Yes, but you still have to give us the details. Without knowing any of the details I can't suggest anything. -- Biff Microsoft Excel MVP "yshridhar" wrote in message ... Thank you Mr. T.Valko. But my data is not grouped. I have to update it daily. Is there any procedure for unsorted data regards Sridhar "T. Valko" wrote: Yes, but you need to give us some of details. Note that it's much simpler if the data is sorted or grouped together: Tom...10 Sue...21 Tom...17 Lou...14 Sue...10 Easier to deal with if it's like this: Tom...10 Tom...17 Sue...21 Sue...10 Lou...14 -- Biff Microsoft Excel MVP "yshridhar" wrote in message ... Is there any advanced function to vlookup to extract multiple data if the required item is repeated in the data? Thank you Sridhar |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup - multiple values
You seem extremely reluctant to describe your problem. I've asked you twice
to do so. So, I'm going to decline your offer. -- Biff Microsoft Excel MVP "yshridhar" wrote in message ... Thank you Mr. T. Valko. Can i send my data file. How to email it to you? Sridhar "T. Valko" wrote: Yes, but you still have to give us the details. Without knowing any of the details I can't suggest anything. -- Biff Microsoft Excel MVP "yshridhar" wrote in message ... Thank you Mr. T.Valko. But my data is not grouped. I have to update it daily. Is there any procedure for unsorted data regards Sridhar "T. Valko" wrote: Yes, but you need to give us some of details. Note that it's much simpler if the data is sorted or grouped together: Tom...10 Sue...21 Tom...17 Lou...14 Sue...10 Easier to deal with if it's like this: Tom...10 Tom...17 Sue...21 Sue...10 Lou...14 -- Biff Microsoft Excel MVP "yshridhar" wrote in message ... Is there any advanced function to vlookup to extract multiple data if the required item is repeated in the data? Thank you Sridhar |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup - multiple values
See this:
http://office.microsoft.com/en-ca/ex...260381033.aspx -- Biff Microsoft Excel MVP "yshridhar" wrote in message ... Thank you Mr. T. Valko. Can i send my data file. How to email it to you? Sridhar "T. Valko" wrote: Yes, but you still have to give us the details. Without knowing any of the details I can't suggest anything. -- Biff Microsoft Excel MVP "yshridhar" wrote in message ... Thank you Mr. T.Valko. But my data is not grouped. I have to update it daily. Is there any procedure for unsorted data regards Sridhar "T. Valko" wrote: Yes, but you need to give us some of details. Note that it's much simpler if the data is sorted or grouped together: Tom...10 Sue...21 Tom...17 Lou...14 Sue...10 Easier to deal with if it's like this: Tom...10 Tom...17 Sue...21 Sue...10 Lou...14 -- Biff Microsoft Excel MVP "yshridhar" wrote in message ... Is there any advanced function to vlookup to extract multiple data if the required item is repeated in the data? Thank you Sridhar |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i get multiple values in vlookup? | Excel Worksheet Functions | |||
| VLookup - multiple values | Excel Worksheet Functions | |||
| How do I allow for multiple values in VLOOKUP? | Excel Worksheet Functions | |||
| vlookup, multiple values, sum values into one cell?? | Excel Worksheet Functions | |||
| VLOOKUP FOR MULTIPLE VALUES | Setting up and Configuration of Excel | |||
Linear Mode
