I'm trying to get a function that I can pass the quarter & the HandsetName and it will return the correct value for me but I'm not sure how to do this.

This is what I have so far, but I don't know how to properly reference my cells to get the values out. See the 3 lines following "'NOT SURE HOW TO DO THIS PROPERLY"
<pre>Sub GetPredeploymentTIL(rQtrin As String, sTypein As String, DevIDin As String)
'REMOVE THESE LINES FOR PRODUCTION
setPaths
Set xlapp = CreateObject("excel.application")
'END REMOVE THESE LINES FOR PRODUCTION