Checking string text (find it hard to code, please help)

Hi,
I am currently facing an issue on how to code a VBA program.
I will expose the problem and if someone can help me it would be very helpful

I attached an Excel file with an example of the kind of data I need to analyse.

I need to analyse each column but for simplicity, lets just concider there is only one.
Look at the allocation column (red text) and we will have to take the Allocations one by one (let start with Apple)
We need to find the corresponding Column (here it is Apple link) and the corresponding cells which is D2.

Now the hard part start. The text in green (Apple-145) is some kind of ID, and the text under the green text is a parameter.
We need to check within this cell, that for every ID, there is a parameter under it.

For example, D2 is fine, because there is one parameter under each ID (Apple-145 got 1 - Fruit and Apple-168 got 2 -Sugar.
The code should then have some kind of variable saying it is fine.

Then the code go to the next Allocation, here it is Tree. The code try to find the column but ''Tree link'' is not here, so it is fine.

THen the code look at the next Allocation ( ''Bottle") and look for the Bottle link column and the corresponding cell (here E2)
Same code as for the Apple, but this time it should have one variable saying that there is a problem because Bottle-545 don't have anything parameter below before the next ID (Bottle-752) starts.

Please help me if you can. I am pretty new to VBA and this problem just block me completely.

Thanks in advance
Lucas