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