Sir, mai ek invoice banaya hu usme brand name or product name ka use kar k ek dependent drop down banaya hu mai ye chahta hu ki dget function use kar k rate ko fatch karu lakin ye sirf ek hi cell me ho raha hai aage dusre cell me formula copy karne par error ho raha hai kya kare..
Its works if we are searching single id, But its not working in full student pay fees list. "Automated Fees Status and fees receipt Software in Excel in hindi".