populate table with data depending on item selected in drop down list

And what are you expecting it to do? Can you please mock up manually what you want to see in B52 if the formula is working? Please remember that whilst you know exactly what you want, we can't read your mind.