Dear experts
I have raw data which is need to validate as two category Demerits and Non Demerits. from different depends upon value of count.
i have support sheet with set of segment if set of segment match with rawdata Merit code col J:J, result will be taken from same segment of result
for e.g
if tier is BSE first match sheet BSE if product ID is repeat twice and merit code SAP and SMB , check if these criteria match same segment in BSE sheet under Individual get result of segment result. Demertis and Non Demerits,
if not match then result not found.
i want result in B and L column
B has to fill down how many times product repeat in A:A
L result from sheets if Tier,Capcitivy,Merits Code.
Bookmarks