| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup help with multiple results
I have a range of cells which has a master list of my inventory. Headers are
Category, Vendor, Item, Price. This list is in Sheet 1. I have 12 different categories of inventory. What I want to do is: On Sheet 2 I have entered a Vlookup of one of the twelve categories. My problem is that I only get the first row of data. How can I get all the subsequent rows of this same category onto Sheet 2. Thank you in advance Gerd |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup help with multiple results
use AutoFilter and copy rather than VLOOKUP()
-- Gary''s Student - gsnu200810 "Gerd" wrote: I have a range of cells which has a master list of my inventory. Headers are Category, Vendor, Item, Price. This list is in Sheet 1. I have 12 different categories of inventory. What I want to do is: On Sheet 2 I have entered a Vlookup of one of the twelve categories. My problem is that I only get the first row of data. How can I get all the subsequent rows of this same category onto Sheet 2. Thank you in advance Gerd |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup help with multiple results
Thanks a lot. That works great.
"Gary''s Student" wrote: use AutoFilter and copy rather than VLOOKUP() -- Gary''s Student - gsnu200810 "Gerd" wrote: I have a range of cells which has a master list of my inventory. Headers are Category, Vendor, Item, Price. This list is in Sheet 1. I have 12 different categories of inventory. What I want to do is: On Sheet 2 I have entered a Vlookup of one of the twelve categories. My problem is that I only get the first row of data. How can I get all the subsequent rows of this same category onto Sheet 2. Thank you in advance Gerd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I SUM multiple results from a VLOOKUP? | Excel Worksheet Functions | |||
| Multiple results in Vlookup | Excel Discussion (Misc queries) | |||
| Looking up multiple results with VLOOKUP | Excel Worksheet Functions | |||
| Vlookup, multiple results (in different cells)? | Excel Worksheet Functions | |||
| Add multiple vlookup results | Excel Worksheet Functions | |||
Linear Mode
