Spreadsheet: 148434d1333400767-vlookup-multiple-values-forum-example
Sheet: Tab 2

String | gen | aux | ce | proj | [NAME] | facil | hcc | tcc | amount | desc
 | 242 | 0001 |  |  |  | BANK04 |  |  | 4 | ACCRUED VACATIONS
 | 242 | 0001 |  |  |  | YR2009 |  |  |  | ACCRUED VACATIONS
 | 242 | 0001 |  |  |  | YR2010 |  |  | -207008 | ACCRUED VACATIONS
 | 242 | 0001 |  |  |  | YR2011 |  |  | -250709 | ACCRUED VACATIONS
 | 242 | 0001 |  |  |  | YR2012 |  |  | -252934 | ACCRUED VACATIONS
 | 242 | 0001 |  |  |  | YR2013 |  |  |  | ACCRUED VACATIONS
 | 242 | 0001 |  |  | [NAME] | YR1999 |  |  | -4 | ACCRUED VACATIONS
 | 242 | 0001 |  |  | [NAME] | YR2009 |  |  |  | ACCRUED VACATIONS
 | 242 | 0001 |  |  | [NAME] | YR2010 |  |  | 206881 | ACCRUED VACATIONS
 | 242 | 0001 |  |  | [NAME] | YR2011 |  |  | 211000 | ACCRUED VACATIONS
 | 242 | 0001 |  |  | [NAME] | YR2012 |  |  |  | ACCRUED VACATIONS
 | 242 | 0001 |  |  | L0029 | YR2010 |  |  | 1 | ACCRUED VACATIONS
 | 242 | 0002 |  |  |  |  |  |  | 26 | ACCRUED PAYROLL
 | 242 | 0003 |  |  |  |  |  |  | 24 | ACCRUED INSURANCE
 | 242 | 0005 |  |  | 14870 |  |  |  | 8 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 14880 | [NAME] |  |  | 35 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 14880 | CMCMPB |  |  | -1 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 14885 |  |  |  | -8 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 14890 |  |  |  | -16 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 14900 |  |  |  | 3 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 14900 | HMCMD1 |  |  | -1 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 14910 |  |  |  | 3 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 14911 |  |  |  | 11 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 14912 |  |  |  | 5 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 14913 |  |  |  | -5 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 14920 |  |  |  | -2201 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 14921 |  |  |  | 145 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 14925 |  |  |  | -518 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 14930 |  |  |  | -7 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 14950 |  |  |  | -1 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 14960 |  |  |  | 1 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 14980 |  |  |  | -1 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15000 | YR0091 |  |  | -2 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15000 | YR0092 |  |  | 2 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15000 | YR1993 |  |  | 7 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15000 | YR1994 |  |  | 4 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15000 | YR1995 |  |  | 3 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15000 | YR1996 |  |  | 4 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15000 | YR1997 |  |  | 3 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15000 | YR1998 |  |  | 2 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15000 | YR2000 |  |  | -1 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15000 | YR2001 |  |  | 1 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15000 | YR2002 |  |  | -2 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15000 | YR2003 |  |  | 1 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15000 | YR2004 |  |  | 4 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15000 | YR2005 |  |  | 1 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15000 | YR2006 |  |  | -1 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15000 | YR2007 |  |  | -1 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15000 | YR2008 |  |  | -3 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15000 | YR2009 |  |  | -3 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15000 | YR2010 |  |  | -1 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15000 | YR2011 |  |  | 1 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15000 | YR2012 |  |  |  | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15010 | YR0092 |  |  | -1 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15010 | YR1992 |  |  | -2 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15010 | YR1993 |  |  | -2 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15010 | YR1994 |  |  | 2 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15010 | YR1999 |  |  | 1 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15010 | YR2000 |  |  | -1 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15015 |  |  |  | -775 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15020 |  |  |  | 2 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15030 |  |  |  | 1 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15040 |  |  |  | -8 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15050 |  |  |  |  | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15070 |  |  |  | -2 | PAYROLL DEDUCTIONS
 | 242 | 0005 |  |  | 15870 |  |  |  | 2 | PAYROLL DEDUCTIONS
 | 242 | 0008 |  |  |  |  |  |  | -6 | EXCHANGE GAS
 | 242 | 0008 |  |  | 15005 |  |  |  | -6 | EXCHANGE GAS
 | 242 | 0008 |  |  | 15006 |  |  |  | -321988 | EXCHANGE GAS
 | 242 | 0010 |  |  |  |  |  |  | -39018 | UNCLAIMED ACCOUNTS
 | 242 | 0011 |  |  | 15090 | 101200 |  |  | 1 | WITHHELD ACCOUNTS
 | 242 | 0016 |  |  | 15120 |  |  |  | -2499 | DENTAL ASSISTANCE PLAN
 | 242 | 0017 |  |  | 15130 | [NAME] |  |  |  | CMEP
 | 242 | 0017 |  |  | 15130 | CMCMPB |  |  | -17366 | CMEP
 | 242 | 0017 |  |  | 15130 | CMCMPC |  |  | -1 | CMEP
 | 242 | 0017 |  |  | 15131 |  |  |  | -3108 | CMEP
 | 242 | 0020 |  |  | 15140 |  |  |  | -15 | RATE REFUNDS (SUSPENDED)
 | 242 | 0020 |  |  | 15150 |  |  |  | 1 | RATE REFUNDS (SUSPENDED)
 | 242 | 0022 |  |  | 15170 | 101290 |  |  | -164 | RATE REFUNDS AND REDUCTIONS
 | 242 | 0022 |  |  | 15170 | 101290 |  | 0000 | -1 | RATE REFUNDS AND REDUCTIONS
 | 242 | 0022 |  |  | 15170 | 101300 |  |  | 107 | RATE REFUNDS AND REDUCTIONS
 | 242 | 0022 |  |  | 15170 | 101300 |  | 0000 | -1 | RATE REFUNDS AND REDUCTIONS
 | 242 | 0022 |  |  | 15180 | 101360 |  |  | -9 | RATE REFUNDS AND REDUCTIONS
 | 242 | 0031 |  |  |  |  |  |  | 33 | RETIREMENT INCOME PLAN ACCRUAL
 | 242 | 0041 |  |  |  | HMCHM1 |  |  | -1 | HEALTH MAINTENANCE ORGANIZATION
 | 242 | 0041 |  |  |  | HMCMD1 |  |  | -1 | HEALTH MAINTENANCE ORGANIZATION
 | 242 | 0041 |  |  | 14900 |  |  |  | 1 | HEALTH MAINTENANCE ORGANIZATION
 | 242 | 0047 |  |  |  | 101236 |  |  | -6 | SPECIAL EMPLOYEE SEVERANCE PROGRAM
 | 242 | 0047 |  |  |  | 101249 |  |  | 1 | SPECIAL EMPLOYEE SEVERANCE PROGRAM
 | 242 | 0047 |  |  |  | 101256 | BBAL |  | 1 | SPECIAL EMPLOYEE SEVERANCE PROGRAM
 | 242 | 0047 |  |  |  | 101257 |  |  | 1 | SPECIAL EMPLOYEE SEVERANCE PROGRAM
 | 242 | 0047 |  |  |  | 101257 | BBAL |  | -1 | SPECIAL EMPLOYEE SEVERANCE PROGRAM
 | 242 | 0047 |  |  |  | 101258 |  |  | -1 | SPECIAL EMPLOYEE SEVERANCE PROGRAM
 | 242 | 0047 |  |  |  | 101258 | BBAL |  | 1 | SPECIAL EMPLOYEE SEVERANCE PROGRAM
 | 242 | 0047 | 1010 |  |  | 101238 | 2351 |  | 1 | SPECIAL EMPLOYEE SEVERANCE PROGRAM
 | 242 | 0047 | 1010 |  |  | 101256 |  |  | -3 | SPECIAL EMPLOYEE SEVERANCE PROGRAM
 | 242 | 0077 |  |  | 15271 |  |  |  | 2 | PENSION RESTORATION PLAN
 | 242 | 0079 |  |  | 15273 |  |  |  | -1 | POST RETIRE BENEFITS
 | 242 | 0080 |  |  | 15860 |  |  |  | 5 | POSTEMPLOYMENT BENEFIT - CURRENT
 | 242 | 0081 |  |  | 15790 |  |  |  | 7 | INVENTORY DEFECIT-STORED GAS DELIVE
 | 242 | 0083 |  |  | 16440 |  |  |  | 2 | INSURANCE TRANSACTION
 | 242 | 3434 |  |  |  |  |  |  | -4 | PRICE [NAME]-CURRENT
 | 242 | 4900 |  |  | 15900 | DIR002 |  |  | 5 | MISC CURRENT AND ACCRUED LIABILITY
 | 242 | 5035 |  |  |  |  |  |  | 9 | CUST A/R CREDIT BALANCES
 | 242 | 5035 |  |  | 30870 |  |  |  | -3759106 | CUST A/R CREDIT BALANCES
 | 242 | 5035 |  |  | 30871 |  |  |  | -127975 | CUST A/R CREDIT BALANCES
 | 242 | 9005 |  |  | 15820 | LG3295 |  |  | -1482248 | CURRENT ENVIRONMENTAL COSTS
 | 242 | 9005 |  |  | 15828 |  |  |  | -5 | CURRENT ENVIRONMENTAL COSTS
 | 242 | 9900 |  |  | 15110 | 101230 |  |  | -2 | OTHER
 | 242 | 9900 |  |  | 15110 | 101240 |  |  | -2 | OTHER
 | 242 | 9900 |  |  | 15290 |  |  |  | 3070788 | OTHER
 | 242 | 9900 |  |  | 15291 |  |  |  | -3080821 | OTHER
 | 242 | 9900 |  |  | 15330 |  |  |  | -18 | OTHER
 | 242 | 9900 |  |  | 15350 | 101470 |  |  | -364 | OTHER
 | 242 | 9900 |  |  | 15350 | 101480 |  |  | -6 | OTHER
 | 242 | 9900 |  |  | 15485 |  |  |  | -20614 | OTHER
 | 242 | 9900 |  |  | 15486 |  |  |  | -10681 | OTHER
 | 242 | 9900 |  |  | 15487 |  |  |  | -44860 | OTHER
 | 242 | 9900 |  |  | 15521 | RY9192 |  |  | -1 | OTHER
 | 242 | 9900 |  |  | 15521 | RY9293 |  |  | 9 | OTHER
 | 242 | 9900 |  |  | 15521 | RY9394 |  |  | 7 | OTHER
 | 242 | 9900 |  |  | 15522 | RY9192 |  |  | -3 | OTHER
 | 242 | 9900 |  |  | 15522 | RY9293 |  |  | -13 | OTHER
 | 242 | 9900 |  |  | 15522 | RY9394 |  |  | -9 | OTHER
 | 242 | 9900 |  |  | 15586 |  |  |  | -1 | OTHER
 | 242 | 9900 |  |  | 15587 |  |  |  | -87297 | OTHER
 | 242 | 9900 |  |  | 15588 |  |  |  | -14727 | OTHER
 | 242 | 9900 |  |  | 15781 |  |  |  | -1 | OTHER
 | 242 | 9900 |  |  | 15782 |  |  |  | -2 | OTHER
 | 242 | 9900 |  |  | 15790 |  |  |  | 1 | OTHER
 | 242 | 9900 |  |  | 15850 | 101410 |  |  | -536484 | OTHER
 | 242 | 9900 |  |  | 15850 | 101430 |  |  | 536384 | OTHER
 | 242 | 9900 |  |  | 15884 | SA*FLO |  |  | 361058 | OTHER
 | 242 | 9900 |  |  | 15884 | SA*INC |  |  | 56454 | OTHER
 | 242 | 9900 |  |  | 15884 | 100185 |  |  | -60 | OTHER
 | 242 | 9900 |  |  | 15891 |  |  |  | -14496 | OTHER
 | 242 | 9900 |  |  | 65884 | SA*FLO |  |  | 17598 | OTHER
 | 242 | 9900 |  |  | 65884 | SA*INC |  |  | -17548 | OTHER
 | 242 | 9900 |  | [NAME] | 15290 |  |  |  | 11 | OTHER
 | 242 | 9900 |  | BON10 | 15290 |  |  |  | 4 | OTHER
 | 242 | 9900 |  | BON10 | 15291 |  |  |  |  | OTHER
 | 242 | 9900 |  | BON11 | 15290 |  |  |  |  | OTHER
 | 242 | 9900 |  | BON11 | 15291 |  |  |  | -192843 | OTHER
 | 242 | 9900 |  | BON12 | 15291 |  |  |  |  | OTHER
 | 242 | 9900 |  | D*EXC | 15884 | SA*INC |  |  | -7500 | OTHER
 | 242 | 9900 |  | D*PUT | 15884 | SA*FLO |  |  | -360985 | OTHER
 | 242 | 9900 |  | D*PUT | 15884 | SA*INC |  |  | -48939 | OTHER
 | 242 | 9900 |  | PER10 | 15290 |  |  |  |  | OTHER
 | 242 | 9900 |  | PER10 | 15291 |  |  |  | -1 | OTHER
 | 242 | 9900 |  | PER11 | 15290 |  |  |  |  | OTHER
 | 242 | 9900 |  | PER11 | 15291 |  |  |  | -10890 | OTHER
 | 242 | 9900 |  | SIP09 | 15290 |  |  |  | -1 | OTHER
 | 242 | 9907 |  |  |  | NI2000 |  |  | -2 | CHANGE IN CONTROL ACCRUEL
 | 242 | 9907 |  | SCA01 |  | NI2000 |  |  | -1 | CHANGE IN CONTROL ACCRUEL
 | 242 | 9907 |  | SCA02 |  | NI2000 |  |  | -1 | CHANGE IN CONTROL ACCRUEL
 | 242 | 9907 | 1010 |  |  | NI2000 |  |  | 1 | CHANGE IN CONTROL ACCRUEL
 | 242 | 9907 | 1010 | SCA01 |  | NI2000 |  |  | 1 | CHANGE IN CONTROL ACCRUEL
 | 242 | 9950 |  |  | 15280 |  |  |  | -35 | ACCRUED PLANT IN SERVICE