Vlook up having blank cells

  • Hi Am looking for a formula of Vlook up if possible. I have 2 sheets in excel file (Account Sheet & Account List), i want to compare if the account column B in account sheet is equal to the account list ,provide the values as per column B (account group),even if there is a blank cell from account list -pick up the values stated in sheet 2.

    Secondly, duplicate rows with different amount (Column H to J) - sum up the total amount per items without taking the duplicate