vlookup - multiple values

[yshridhar]

Is there any advanced function to vlookup to extract multiple data if the
required item is repeated in the data?
Thank you
Sridhar

 

[T. Valko]

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

 

[yshridhar]

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

 

[Duke Carey]

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/datamenu/dataexamples/externaldataexamples.htm

 

[T. Valko]

Yes, but you still have to give us the details. Without knowing any of the
details I can't suggest anything.

 

[yshridhar]

Thank you Mr. T. Valko. Can i send my data file. How to email it to you?
Sridhar

 

[T. Valko]

You seem extremely reluctant to describe your problem. I've asked you twice
to do so. So, I'm going to decline your offer.

 

[T. Valko]

See this:

http://office.microsoft.com/en-ca/excel/HA012260381033.aspx