Spreadsheet: 164061d1340635730-table-lookup-help-required-lookupaccount-and-bal
Sheet: Sheet1

 |  |  |  |  |  |  |  | Table 2 |  |  |  |  | Table 3
 |  |  |  |  |  |  |  | Account | Name | Balance |  |  | Account |  |  |  |  |  | Name |  |  |  |  |  |  |  |  |  | Balance
 |  |  |  |  |  |  |  | Column1 | Column2 | Available |  |  | Column1 | Column13 | Column133 | Column132 | Column14 | Column12 | Column2 | Column22 | Column227 | Column226 | Column225 | Column224 | Column223 | Column222 | Column23 | Column3 | Available
 |  |  |  |  |  |  |  |  |  |  |  |  | B500 |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 10.38
 |  |  |  |  |  |  |  |  |  |  |  |  | B500 |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 0
Table 1a |  |  |  |  |  |  |  |  |  |  |  |  | B500 |  |  |  |  |  | Rich S |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | B500 |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 30.89
Account |  |  |  |  |  |  |  |  |  |  |  |  | B500 |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 25
B500 |  |  |  |  |  |  |  |  |  |  |  |  | BD |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 0
BD |  |  |  |  |  |  |  |  |  |  |  |  | BD |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 15.46
VC |  |  |  |  |  |  |  |  |  |  |  |  | BD |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 54.52
 |  |  |  |  |  |  |  |  |  |  |  |  | BD |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | BF |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 0
Table 1b |  |  |  |  |  |  |  |  |  |  |  |  | BF |  |  |  |  |  | Rich S |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | BF |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 65.84
Account |  |  |  |  |  |  |  |  |  |  |  |  | BF |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 75.29
PS |  |  |  |  |  |  |  |  |  |  |  |  | PP |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 0
B500 |  |  |  |  |  |  |  |  |  |  |  |  | PP |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 43.23
SJ |  |  |  |  |  |  |  |  |  |  |  |  | PP |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 28.37
 |  |  |  |  |  |  |  |  |  |  |  |  | PS |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | PS |  |  |  |  |  | Rich S |  |  |  |  |  |  |  |  |  | 62.45
Table 1c |  |  |  |  |  |  |  |  |  |  |  |  | SB |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 53.24
 |  |  |  |  |  |  |  |  |  |  |  |  | SB |  |  |  |  |  | Rich S |  |  |  |  |  |  |  |  |  | 0
Account |  |  |  |  |  |  |  |  |  |  |  |  | SJ |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 0
SJ |  |  |  |  |  |  |  |  |  |  |  |  | SJ |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 1000
PS |  |  |  |  |  |  |  |  |  |  |  |  | SJ |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 0
B500 |  |  |  |  |  |  |  |  |  |  |  |  | SJ |  |  |  |  |  | Rich S |  |  |  |  |  |  |  |  |  | 84.65
 |  |  |  |  |  |  |  |  |  |  |  |  | SJ |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 12.52
 |  |  |  |  |  |  |  |  |  |  |  |  | VC |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 59.54
 |  |  |  |  |  |  |  |  |  |  |  |  | VC |  |  |  |  |  | Rich S |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  | VC |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 63.24