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