trying to display another column after data validation list

Hey,

I have a problem with this workbook, i know how to do it by nesting if functions but i want a neater way to do this. I have tried if(index(match)) type formula and haven't got it to work, any help would be appreciated.Example.xlsx

Put this in G16:

=IFERROR(VLOOKUP(G15,$C$11:$D$36,2,0),"Not Available")

Hope this helps.

Pete

thanks mate you are a champion