Dear sir,
Reference to attached sheet, I wanted to lookup the vendor name from Hire and Hire2 sheet, Column O contains Voucher number Column C should the vendor name, column C should come from Hire and Hire2 sheet on the basis of Voucher name.
But if the Vendor name from Hire2 sheet then account name should be fuel expenses.
Reference to attached sheet, I wanted to lookup the vendor name from Hire and Hire2 sheet, Column O contains Voucher number Column C should the vendor name, column C should come from Hire and Hire2 sheet on the basis of Voucher name.
But if the Vendor name from Hire2 sheet then account name should be fuel expenses.