Lookup Functions

[jcooksey]

When using vlookup, how would I get to the next line in a series?
want to pull in specific cells based on broad criteria. For example
in market 501, I want to pull in all the addresses and stores in tha
market-if I use vlookup it will only pull the first one it comes to-i
there a "next "function that will skip the first and pull in the secon
and third ect.

Or is there a better way to get at this.

Thank

 

[Anne Troy]

Perhaps you need something like this:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=8
**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
********************************

 

[Jason Morin]

You really don't want to pull in multiple values or
strings into cell. It gets messy. I'd suggest
investigating AutoFilter:

http://www.contextures.com/xlautofilter01.html

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Hi
try the following kind of array formula (data in column A/B and formula
entered with cTRL+sHIFT+ENTER)
=INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100="market
501",ROW($A$1:$A$100)),ROW(1:1)))
and copy this down