I have a worksheet where I have a drop down list and I am trying to auto fill the column to the right. I attached the Excel file. I am having some issue getting the value to populate properly. Could someone please take a look at this and tell me what I am doing wrong?
The field I am testing this on is D27 on the Worksheet tab.
I keep getting #NAME? but it is suppose to be pulling in the RATE (20) from the tab sheet2.