Find offset cell vaule based on selected value in a ComboBox

[Arnebjarne]

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..

Please Login or Register  to view this content.

This is the relevat part of the userform:

Please Login or Register  to view this content.

[Akuini]

Try something like this:

Please Login or Register  to view this content.

Test2 should get the value that you want.
If it doesn't work then please attach your sample workbook.