I have 2 sheets and am looking to use a drop down on sheet 2 "Quotes" Cell B11 to return a value from Sheet 1 "Rates" E6:E39 into Cell B13.
I have the dropdown list pulling from Sheet 1 A6:A39, I just can't get the values to line up and return in B13.
Any help would be greatly appreciated, I feel as though I have looked everywhere.
I have the dropdown list pulling from Sheet 1 A6:A39, I just can't get the values to line up and return in B13.
Any help would be greatly appreciated, I feel as though I have looked everywhere.