Hi.
You guys have been most helpful so far on my projcet, so I'm hoping for a posistive answer here as well.
I have a userform in my main sheet. The userform contains among othertings, a ComboBox. To fill the ComboBox I use the range F2:F100 from another sheet. That range displays the value of every 13th cell in column B: B3, B16 ,B29, B42 and so on. The reason I display the values in row F is to get one coherent list in the ComboBox. The selected value of the ComboBox is transfered into my main sheet when I press my OK button.
Here comes the tricky part I haven't figuret out yet.
I also want to transfer the value of the respective cell six cells below the selected value in the ComboBox.
So, in the ComboBox I select "Example". That value is found in F3, but it is really the value of B16. I then want the value in B22 to be transfered as well.
How do I find that value?
I understand that It can be done with some combination of INDEX,MATCH or OFFSET,MATCH, or maybe another lookup funcotin, but my knowledge is to short.
I have tried, but..
This is the relevat part of the userform:
Bookmarks