I am attempting to create what should be a simple formula. I am sure there
are better ways to do this but I am somewhat new so just going for what I
know how to use. I have attempted VLOOKUP, but I get a bit confused on this.

D5 is a drop down menu which is the name. (This Cell never moves).
c5,c6,c7, etc€¦ is a numerical value I would like my new target cell to show.
I only have 27 names.

Heres my formula:
=LOOKUP(D5,{"name1","name2","name3","name4","name5 ","name6","name7","name8","name9","name10","name11 ","name12","name13","name14","name15","name16","na me17","name18","name19","name20","name21","name22" ,"name23","name24","name25","name26","name27"},{"c 5","c6","c7","c8","c9","c10","c11","c12","c13","c1 4","c15","c16","c17","c18","c19","c20","c21","c22" ,"c23","c24","c25","c26","c27","c28","c29","c30"," c31"})

I think this formula is perfect except instead of showing €œc5€�, etc€¦ I want
it show the value of C5.

Thanks in Advance