Spreadsheet: 871412d1717794880-having-trouble-figuring-out-a-lookup-problem-lookup-example
Sheet: 1

Location | Asset # | Class | Progressive Type | Denom | Reset Amt | Prog ID | Prog Pool | 2024-06-02 00:00:00
C-65(6-10) | 9030 | II | Linked | 0.01 | 10 | 578 | 578 - $8.80
C-65(6-10) | 9030 | II | Linked | 0.01 | 25 | 577 | 577 - $8.80
C-65(6-10) | 9030 | II | Linked | 0.01 | 800 | 576 | 576 - $8.80
C-65(6-10) | 9030 | II | Linked | 0.01 | 10000 | 575 | 575 - $8.80
A-16-(1-6) | 9919 | II | Linked | 0.01 | 5000 | 117 | 117 - $2.00
B-3(1-4,13-16) | 10587 | II | Linked | 0.01 | 10 | 578 | 578 - $10 NGC
B-3(1-4,13-16) | 10587 | II | Linked | 0.01 | 25 | 577 | 577 - $25 NGC
B-3(1-4,13-16) | 10587 | II | Linked | 0.01 | 800 | 576 | 576 - $800 NGC
B-3(1-4,13-16) | 10587 | II | Linked | 0.01 | 10000 | 575 | 575 - $10k NGC
C-19(1-4) | 10261 | II | Linked | 0.01 | 10 | 5013 | 578 - 222735
C-19(1-4) | 10261 | II | Linked | 0.01 | 25 | 5012 | 577 - 222735
C-19(1-4) | 10261 | II | Linked | 0.01 | 800 | 5011 | 576 - 222735
C-19(1-4) | 10261 | II | Linked | 0.01 | 10000 | 5010 | 575 - 222735
A-6(1-2) | 9917/9918 | II | Linked | 0.01 | 50 | 906 | 906 - NCG
A-6(1-2) | 9917/9918 | II | Linked | 0.01 | 500 | 905 | 905 - NCG
A-6(1-2) | 9917/9918 | II | Linked | 0.01 | 8800 | 904 | 904 - NCG
I-31(1-3) | 11915-11917 | II | Linked | 0.01 | 800 | 5087 | 2181 - $800
I-31(1-3) | 11915-11917 | II | Linked | 0.01 | 8000 | 5084 | 2183 - $8K
C-19(1-6) | 10261 | II | Linked | 0.01 | 250 | 1587 | 1587 - $250
C-19(1-6) | 10261 | II | Linked | 0.01 | 500 | 1586 | 1586 - $500
C-19(1-6) | 10261 | II | Linked | 0.01 | 5000 | 1585 | 1585 - $5K
F-16(1-6) | 11322-11327 | II | Linked | 0.01 | 10 | 578 | 578 - $10
F-16(1-6) | 11322-11327 | II | Linked | 0.01 | 25 | 577 | 577 - $25
F-16(1-6) | 11322-11327 | II | Linked | 0.01 | 800 | 576 | 576 - $800
F-16(1-6) | 11322-11327 | II | Linked | 0.01 | 10000 | 575 | 575 - $10k
A-25(1-5) | 9199 | II | Linked | 0.01 | 500 | 1312 | 1272 - $500
A-25(1-5) | 9199 | II | Linked | 0.01 | 10000 | 1312 | 1271 - $10k
A-23(1-5) | 9189-9193 | II | Linked | 0.01 | 10 | 2111 | 1203 7.50 0.01
A-23(1-5) | 9189-9193 | II | Linked | 0.01 | 25 | 2111 | 1202 7.50 0.01 427
A-23(1-5) | 9189-9193 | II | Linked | 0.01 | 500 | 2111 | 1201 7.50 0.01
A-23(1-5) | 9189-9193 | II | Linked | 0.01 | 10000 | 2111 | 1200 7.50 0.01
A-23(16-20) | 9194 | II | Linked | 0.01 | 500 | 1312 | 1251 - $500
A-23(16-20) | 9194 | II | Linked | 0.01 | 5000 | 1312 | 1250 - $5000
D-8(1-10) | 8960-8969 | II | Linked | 0.01 | 500 | 5022 | PC_356_1_0 1313 500.00 0.01
D-8(1-10) | 8960-8969 | II | Linked | 0.01 | 10000 | 5021 | PC_356_1_0 1312 10000.00 0.01
D-8(1-10) | 8960-8969 | II | Linked | 0.02 | 500 | 1313 | PC_356_1_0 1313 500.00 0.02
D-8(1-10) | 8960-8969 | II | Linked | 0.02 | 10000 | 1312 | PC_356_1_0 1312 10000.00 0.02
D-8(1-10) | 8960-8969 | II | Linked | 0.05 | 500 | 5024 | PC_356_1_0 1313 500.00 0.05
D-8(1-10) | 8960-8969 | II | Linked | 0.05 | 10000 | 5023 | PC_356_1_0 1312 10000.00 0.05
H-9(1-3) | 11435 | II | Linked | 0.25 | 250 | 5036 | 1529 - $250 MD
H-9(1-3) | 11435 | II | Linked | 0.25 | 800 | 5033 | 1528 - $800 MD
H-9(1-3) | 11435 | II | Linked | 0.25 | 2000 | 5030 | 1527 - $2K MD
H-9(1-3) | 11435 | II | Linked | 0.25 | 10000 | 5027 | 1526 - $10K MD
CC-49(4-9) | 11635 | II | Linked | 0.01 | 800 | 5042 | 1543 - $800
CC-49(4-9) | 11635 | II | Linked | 0.01 | 8000 | 5039 | 1542 - $8K
CC-31(1-8) | 11510-11517 | II | Linked | .01/.02 | 5000 | 5043 | PC_10132020_1_0 1508 5000.00 any
CC-31(1-8) | 11510-11517 | II | Linked | .05/.10 | 10000 | 1962 | PC_10132020_1_0 1514 10000.00 any
F-9-3 | 10730 | II | Stand Alone | 0.01 | 10 | 1962 | 1998 - $10
F-9-3 | 10730 | II | Stand Alone | 0.01 | 25 | 1962 | 1997 - $25
F-9-3 | 10730 | II | Stand Alone | 0.01 | 500 | 1962 | 1996 - $500
F-9-3 | 10730 | II | Stand Alone | 0.01 | 10000 | 1962 | 1995 - $10K
D-57(6-10) | 9957-9961 | III | Linked | 0.01 | 800 | 1963 | 1963 - $800
D-57(6-10) | 9957-9961 | III | Linked | 0.01 | 8000 | 1962 | 1962 - $8K
[NAME]) | 11314-11317 | II | Linked | 0.01 | 25 | 1280 | 1280 - $25
[NAME]) | 11314-11317 | II | Linked | 0.01 | 50 | 1279 | 1279 - $50
[NAME]) | 11314-11317 | II | Linked | 0.01 | 500 | 1278 | 1278 - $500
[NAME]) | 11314-11317 | II | Linked | 0.01 | 5000 | 1277 | 1277 - $5k
[NAME]) | 11495 | II | Linked | 0.01 | 1000 | 1585 | 1551 - $1k
[NAME]) | 11495 | II | Linked | 0.01 | 5000 | 1585 | 1550 - $5k
[NAME]) | 11495 | II | Linked | 0.01 | 10000 | 1585 | 1549 - $10k
H-9(10-12) | 11438-11440 | II | Linked | 0.25 | 250 | 1585 | 1829 - $250
H-9(10-12) | 11438-11440 | II | Linked | 0.25 | 800 | 1585 | 1828 - $800
H-9(10-12) | 11438-11440 | II | Linked | 0.25 | 2000 | 1585 | 1827 - $2K
H-9(10-12) | 11438-11440 | II | Linked | 0.25 | 5000 | 1585 | 117 - $5K GISH
I-41(1-3) | 10853-10855 | II | Linked | 0.01 | 800 | 1585 | PC_389_1_0 1565 800.00 any
I-41(1-3) | 10853-10855 | II | Linked | 0.01 | 15000 | 1585 | PC_389_1_0 1564 15000.00 any
A-31(1-4,17-20) | 11500 | II | Linked | 0.01 | 8000 | 1585 | PC_430_1_0 2089 8000.00 any
C-81(1-3) | 11554 | II | Linked | 0.01 | 8000 | 1585 | PC_390_1_0 1949 8000.00 any
A-23(16-20) | 9194-9198 | II | Linked | 0.01 | 5000 | 2111 | PC_399_1_0 1964 5000.00 any
A-23(16-20) | 9194-9198 | II | Linked | .01/.02 | 100 | 2111 | PC_399_1_0 1968 100.00 any
A-23(16-20) | 9194-9198 | II | Linked | .01/.02 | 500 | 2111 | PC_399_1_0 1965 500.00 any
A-23(16-20) | 9194-9198 | II | Linked | .05/.10 | 200 | 2111 | PC_399_1_0 1969 200.00 any
A-23(16-20) | 9194-9198 | II | Linked | .05/.10 | 1000 | 2111 | PC_399_1_0 1966 1000.00 any
A-23(16-20) | 9194-9198 | II | Linked | 1 | 500 | 2111 | PC_399_1_0 1970 500.00 any
A-23(16-20) | 9194-9198 | II | Linked | 1 | 2500 | 2111 | PC_399_1_0 1967 2500.00 any
A-16-(1-6) | 9919 | II | Linked | 0.01 | 5000 | 2111 | PC_447_1_0 2111 5000.00 0.01