Combine IF + VLOOKUP formula

[mal.b.graham]

Hi Guys

I am trying to combine information from one tab to another if an item is marked on the first tab then information to be repeated in second tab..... I have put more information in the attachement............ I have tried to use IF statement and VLookup but just can's to figure out were i am going wrong on the matter

If you need more information please ask

[NBVC]

In A13:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down to A14.

In B13"

Please Login or Register  to view this content.

copied down to B14.

Repeat similarily in other sub groups...