Search for more items based on a criteria

Hi,

I have a very big file for displays, these displays contains 5 or 6 different codes and I need these in an overview.

So in my example i have display code AKS, which contains of AJP;AJQ;AJR;AJS. which i want to have displayed (imagine this is a list with 800 displays with different codes) and i need to sort out 50 tables with about 5 display. So copying and pasting manually will take a lot of time.

When i use a vlookup i just get the first code and not the second or third.

Do you guys now a quick formula which will sort my issue and save me from 3 days work

Thanks in advance!

in H5
=IFERROR(INDEX($C$1:$C$1000,SMALL(IF(($B$1:$B$1000=H$3),ROW($B$1:$B$1000)),ROW(A1)),1),"")
Array formula, use Ctrl-Shift-Enter

and copy down the column as far as the list in column B.

Like this... Enter into cell H5 and pull down

Formula:

Please Login or Register  to view this content.

IMPORTANT
This is an array formula
Enter the formula >> CTRL + SHIFT + ENTER
If entered correctly, the formula will be enclosed in {brackets}
Do not enter the {brackets} manually

Originally Posted by basvankrimpen

Thanks, or i do something wrong, but i get the wrong code. please see attached what i did

You didn't read my instructoons properly.

Array formula, use Ctrl-Shift-Enter