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)