1. This is an invoice coding/company lookup sheet. Vendor Code (VNDR) and Property Number (PPTY) data entered here will populate the account number (ACCT) for the expense. How would the formula read to lookup the account number based on the Vendor and Property data entered? Useful information: - Excel workbook with data is called CODEBOOK; - CODEBOOK contains multiple worksheets based on property number; 500-599;600699;700799;800899; - Below is an example of a sheet from the CODEBOOK