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