a problem extracting data from a database

Hi all

I have recently encountered a problem that i haven't seen before, i hope maybe here i could find the solution...
here the problem:
I'm working with a database, and needs to extract certain data out of it (see attached file). i have two columns: letters and numbers.
up until recently everything was nice and easy: every letter matched with a single number so i could use VLookup to find my data.
recently the database has changed, and now each letters can match with more than one number (up to 20).
my question is this: i need a function of some sort, that by writing the 'Input' box with a letter (B for example - see attached file), will automatically fill the 'output' box with the matching data (the numbers 2,3 and 4 in the example).
my database can be as big as a few Thousand rows...

is what i'm describing sounds possible?

i'll be more than grateful for a response (and a solution... )

thanks in advance

boaz

Sample.xlsx

Amazing!! thanks a LOT!!

A follow up question: how can i improve this formula to fit more than a one column database? (see attached file)

thanks again...

Sample2.xlsx

once again - amazing!!
thanks a lot... you just saved me hours of work...

hey again
i thought i could take it from here, but i got stuck again... need a little more help.

the file attached is the final version of the file i'm using, it is basically the same as before but the locations have changed:
the database and the input/output page are now in different worksheets,
and the direction of the output boxes is now from right to left.
Using your formula, I've succeeded in redirecting the formula to the other worksheet, but i wasn't able to redirect the results
to their proper location... it insists on staying in the wrong box...

sorry for nagging...
and thanks in advance

Sample4.xlsx

hey
thank you again...

i think maybe i didn't explain myself well: i need the formula to be dragged from the right to the left so that each parameter in the "MAIN" worksheet will be paralel to his equivalent in the "DB" worsheet.
for example, the "Number" column should be in B2, the Score column should be in column C2 and so on (See Sample4.xlsx in the previous post).
I apologize for being so petty about it, it just that we're talking about a massive database and it has to work precisely right, other wise it'll take me days to fix it...

thanks.

Wow, i feel stupid... thank you so much!!!
have a great day...