| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I lookup cells that match a specific value and return all.
I have a table that contains several pieces of information on each row. Two
columns of this table include a date and a part number. In a column on a separate sheet I need to be able to search through this table and return a column of part numbers that all have a specific date. This is basically a filtering task, but I need this to be done automatically with formulas or VBA code. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Formula: Return 1st match, then 2nd match, then 3rd match | Excel Discussion (Misc queries) | |||
| Lookup/match value in a different worksheet, and just return a yes | Excel Discussion (Misc queries) | |||
| Lookup formula to return all instances of match? | Excel Discussion (Misc queries) | |||
| Text lookup array and match specific data | Excel Worksheet Functions | |||
| can lookup return err if no match found | Excel Worksheet Functions | |||
Linear Mode
