Macro that will automatically add part number from table

[jamie.c]

Hello everyone,

Im wondering if anyone would be kind enough to help me. I have a worksheet called specification, this has tick box options, that then unhides the relevant parts on the next sheet (Allocation), At the moment I have to manually input the part number for the reservoir, but I think (I could be wrong) but Ive seen examples of vlookups and I think I could use it to input the correct part number automatically according to the the boxes that are ticked, Ive attached a table of part numbers that may help. Can anyone help me out with the code part please? The part numbers are highlighted in red. oh and only one option from each will be ticked.

Many Thanks

Jamie.c