pulling mulitple fields from a table through lookup

[amik]

Some of the fields I want to pull from a table repeat themselves. When I run
the lookup to get the information I need it only pulls up the first one on my
table.

Name Store Id
Rob 12
Mary 13
Rob 14
John 15
Rob 16

Any ideas to display all three would be appreciated.

 

[Sean Timmons]

Seems like you'd want to use a pivot..

Drop name and store ID in the Row Fields section. You can right-click and
select Fiel Settings to remove subtotals...

 

[amik]

I am trying to do it with a lookup function because we want it to look like a
report. the lookup is tied to a drop down box.

Can a pivot table operate like this?

 

[Sean Timmons]

In that case, try using Advanced filter. Highlight your rep and store id in
the main table. Select unique records in the checkbox to avoid multiple
instances of the rep and store id. use the copy to new location to create
your list.