If I understand what you mean, gbaker, the correct answer is this: No matter what lookup function you use—VLOOKUP, MATCH, INDEX, whatever—the function is going to return a single value that can go only in that one cell. If you want multiple values, you have to use multiple formulae, one in each cell.

I've attached your workbook, modified to accomplish that. I didn't bother to use IF(ERROR...) functions so it looks messy, and someone else here may be able to show a better way of doing it generally. And of course you can always write a macro, though there may be reasons why that isn't a practical solution. This works...sort of.

Attached Files

x.xlsx (24.3 KB, 17 views)

Hi Bob,
Was able to make this work. I also tried to do it with another table. I wanted to have the date be the lookup. I moved the date column over to the 1st column and changed the formula but it didn't work. Should this also work if a date is being looked up.