Display occurrences of text and then display it on search page

Hi/Evening All

i have data on a sheet a list of video games and i would like to be able to type in the name or just a part name so for example just sonic rather then sonic 2 and 3 etc

is this possible with vlookup have tried the match function in the past but just said yes or no

thanks for the help

... and expected output is ??????

thank you, just what i wanted

one additionally question? if i was to fill the columns to either side would this pull the system and region so to show the version of said game and what platform it is on ?

again thanks

see attached for what i mean

You Legend i could kiss you

System (Platform ?)

=IFERROR(INDEX(Sega!$C$2:$C$419,MATCH(search!$B6,Sega!$D$2:$D$419,0)),"")

region (Nationality ?)

=IFERROR(INDEX(Sega!$A$2:$A$419,MATCH(search!$B6,Sega!$D$2:$D$419,0)),"")

its OK i shall stick with the first way using the array and match.

however how do i get so it shows correct data, is there an option for a unique key like in
access.

as you can see from attached, when i search for sonic i get 19 results which is correct but the data shown is incorrect for instance i only have "sonic 2" for game gear twice one USA and one Europe but it shows it 3 times and all Europe

Originally Posted by AlKey

Do it with one formula
Enter in B6 and copy across and down

Formula:

Please Login or Register  to view this content.

***Array formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly braces { } appear around your formula.
If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

v	B	C	D
3	Insert Game Here	sonic
4
5	Game	System	Region
6	Sonic Adventure	Dreamcast	Europe
7	Sonic Adventure 2 - Birthday Pack (Limited Edition)	Dreamcast	Japan
8	Sonic The Hedgehog 2	Game Gear	Europe
9	Sonic The Hedgehog 2	Game Gear	USA
10	Sonic The Hedgehog Chaos	Game Gear	Europe
11	Sonic Chaos	Master System	Europe
12	Sonic the Hedgehog	Master System	Europe
13	Sonic the Hedgehog 2	Master System	Europe
14	Sonic CD	Mega CD	Europe
15	Sonic & Knuckles	Mega Drive	Europe
16	Sonic 3D Flickie's Island	Mega Drive	Europe
17	Sonic Spinball	Mega Drive	Europe
18	Sonic The Hedgehog	Mega Drive	Europe
19	Sonic The Hedgehog	Mega Drive	Japan
20	Sonic The Hedgehog 2	Mega Drive	Europe
21	Sonic The Hedgehog 2	Mega Drive	Japan
22	Sonic The Hedgehog 3	Mega Drive	Europe
23	Sonic The Hedgehog 3	Mega Drive	Japan
24	Sonic Jam	Sega Saturn	Europe
25
26
27
28
29

yeah sorry guys ignore my previous email fixed it with this cheers

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.