Getting Key value from last occurrence of another table

[mjh4ck3r]

Hi,
Im fairly very new to VBA Scripting. i have a problem please find the below table
Output column is Comments

Name	Comments
Alert	A1
Phone	P2
Email	Not started

The comment column gets the value from the below table

Name	subname	value
Alert	A1	1​
Alert	A2	0​
Alert	A3	0​
Phone	P1	1​
Phone	P2	1​
Phone	P3	0​
Phone	P4	0​
Email	E1	0​
Email	E2	0​
Email	E3	0​

from first table it should look for the value in second table and check the value column for the last occurrence of 1 say in Alerts A1 is the last has 1 then A1 has to appear in the comment column in table 1, if all three are of alerts are done then its Comments is "Done".

 

[Fluff]

Cross posted Getting Key value from last occurrence of another table

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.