pulling mulitple fields from a table through lookup
 

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.

pulling mulitple fields from a table through lookup
 

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" wrote:

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.

pulling mulitple fields from a table through lookup
 

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" wrote:

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" wrote:

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.

pulling mulitple fields from a table through lookup
 

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.

"amik" wrote:

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" wrote:

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" wrote:

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.