| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Thanks everyone!
"Wendy" wrote: I am trying to look up a value in one column of a table and return data from the corresponding row in the next column over. VLOOKUP only returns the first instance of the lookup value, and I want to show each instance. For example: my table lists dates in one column and tasks in the next and 4 tasks are scheduled on the same date, VLOOKUP only returns the name of the task coresponding to the first cell it found the date in. I want it to return all 4 task names. Is there another function that will do this? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) | |||
| Generating Correlated Random Values in Excel | Excel Discussion (Misc queries) | |||
| Pivot Table Zero Value | Excel Discussion (Misc queries) | |||
| How do you calculate the difference between two values within a p. | Excel Discussion (Misc queries) | |||
| Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
Hybrid Mode
