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

By : user3084662

Source: Stackoverflow.com
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

By : user3084662

Answers

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.

By : adam1969in

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.

By : Scott Craner

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

By : Nestor Mata Cuthbert

This video can help you solving your question :)

By: admin