Multiple lookup vlaues

[BRISBANEBOB]

Is it possible to use multiple lookup values in an array with multiple, uncontiguous data?

The sample spreadsheet may explain it a bit better.

Thanks for any ideas.

[mdbct]

The formula for D13 would be:

Please Login or Register  to view this content.

then copy down.


D17 would be:

Please Login or Register  to view this content.

then copy down.

I'll let you figure out the las one.

[BRISBANEBOB]

Thanks for that.

You can concatenate look-up values but is it possible using vlookup to 'concatenate' the array, or do you have to go the SUMPRODUCT route?

[mdbct]

You could, but you'd have to add an extra column to your table to contain the concatenated data. The sumproduct function is much more versatile.

[BRISBANEBOB]

OK, so you have to use a helper column.

Thanks