Linked Combo Boxes to Display Result in Another Cell

[daneishbacon]

Hi Guys,

New to this forum so please go easy on me!!

I need to create 2 Combo Boxes which run together, i.e. when a selection is made in the 1st Combo Box, the possible selections in the 2nd Combo Box change accordingly.

I have included a quick example of what I am looking to achieve below, where Combo Box 1 selects an options from a Row (One, Two, Three etc), and then Combo Box 2 selects an option from the relevant column (1, 33, 4444 etc)


One Two Three Four Five Combo Box 1 Shows Possible Selections in Rows Combo Box 2 Shows Possible Selections in Relevant Column
1 11 111 1111 11111
2 22 222 2222
3 33 333 3333
4 44 4444 Result of Combo Box 2
5 55 5555
66
77
88
99




I am very new to excel, and do not understand the whole VBA thing, so would be very grateful if someone was able to share a solution that was done completely in standard Excel worksheets. I have used functions such as VLOOKUP etc, so would be very happy if there was a similar solution for this.

Fingers crossed,

Thanks,

Daneishbacon