Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mulitple value lookup | Excel Worksheet Functions | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Lookup mulitple tabs | Excel Worksheet Functions | |||
LookUp with Mulitple Criteria | Excel Discussion (Misc queries) | |||
Pulling date from 1 ws to another while referencing 2 fields | Excel Discussion (Misc queries) |