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

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

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

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

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

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

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

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