## excel one to many look up

Question!

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

You can also use this formula :

``````=IFERROR(INDEX(\$B\$2:\$B\$13,SMALL(IF(\$H2=\$A\$2:\$A\$13,ROW(\$A\$2:\$A\$13)-ROW(\$A\$2)+1),COLUMN(A2))),"")
``````

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

You can use this array formula:

``````=IFERROR(INDEX(\$B\$2:\$B\$13,MATCH(1,(\$A\$2:\$A\$13=\$H\$2)*(COUNTIF(\$H\$2:H\$2,\$B\$2:\$B\$13)=0),0)),"")
``````

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.

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) !!}
``````