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