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!
Bookmarks