Check box and Vlookups

[LordSnow548]

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

 

[Fluff]

Duplicate to: Check box and Vlookup

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.