excel one to many look up


I would like to use a lookup formula to bring back multiple values. For example when it finds more than value in a look up I would like excel to add each value in the adjacent columns.

Can anyone help?

see attached

enter image description here


You can also use this formula :


As this is also an array formula, press Ctrl+Shift+Enter while entering the formula.enter image description here

You can use this array formula:


Being an array formula, put it in the first cell then hit Ctrl-Shift-Enter instead of enter when exiting edit mode. If done correctly then Excel will put {} around the formula.

Then copy/drag across enough columns till you get blanks.

enter image description here

You can use

<input class="form-check-input" type="checkbox" name="hobby[]" value="3" @if(in_array(3, old('hobby'))) checked @endif>

Or you could just switch to use Laravel Collective https://laravelcollective.com/docs/5.3/html#checkboxes-and-radio-buttons

And have code like this instead:

{!! Form::checkbox('name', 'value', true) !!}

This video can help you solving your question :)
By: admin