I have a sheet with 6 check boxes, i have the below formula that will complete a Vlookup when the check box is ticked, what i now need to know how to do is adapt the formula to complete Vlookups when several check boxes are ticked, and then put the result of the vlookups into one cell.

This formula is the current method i am using but as you will see it only works when one check box is ticked and then populates the result into the one cell.

=IF(B2=TRUE,(VLOOKUP(Sheet2!A2,Sheet3!A2:B7,2,FALSE)),"")

Thanks in advance for your help