Vloopup if first result returns null or Zero find next mathcing value

How to get next matching value with the help of Vloopup if first returns null or Zero and fill in the other column value

As in the below example
I have set of data in colA and colB which has applciation name and status

colg and colh has a status of the dependency - based on the colG and colH value we need to fill on the colA and colB value.

Currently it is take first cell value, where as it require next value which is not null or blank.

=IF(ISNA(VLOOKUP(A2,$G$2:$H$28,2,0)),"",VLOOKUP(A2,$G$2:$H$28,2,FALSE))

=OFFSET(INDIRECT("G"&MATCH(A2,$G:$G,0)),0,1)

Attached excel sheet for reference

Any help high appreciated!

Hi NBVC,

Thank you very much! you have made my day!

Three Chrees!
Veman
:-)