Spreadsheet: 66977d1267635943-vlookup-formula-with-match-meterstest
Sheet: Links

Serial Number | Model | Location | Description | Room # | B/W Copy | B/W Print | Color Copy | [NAME] | [NAME] | Fax Sent | Fax Receive | Network Scans
AGF422099 | 6204 | Kramer C | KRMC_220XP | 220 |  | 139429
AGF422146 | 6204 | 721 Barton Springs | 1st floor Rm 124 | 124 |  | 164437
BNB501601 | 721P | Kramer E | KRME_222XP | 222 | 31487 | 84916 | 2396 | 7885 | 7040 | 70 | 0 | 16
CXF033425 | 8560MFP | Kramer C | KRMC_213XC | 213
CXF033431 | 8560MFP | Kramer E | [NAME] | 102
CXF033630 | 8560MFP | Kramer E | KRME_101XC | 101 |  | This should be G695 value of 860930 and this should be the only value filled in!!
CXF034068 | 8560MFP | Kramer C | KRMC_110XC | 110
CXF034241 | 8560MFP | Kramer C | KRMC_226XC | 226
[NAME] | 8560MFP | 721 Barton Springs | 3rd Floor Call Center | 317
CXF300876 | 8560MFP | Kramer D | KRMD_304XC | 304
CXF300877 | 8560MFP | East Branch | EASTB_XC | office
CXF300879 | 8560MFP | Kramer C | KRMC_112XC | 112
CXF334195 | 8560MFP | St. Elmo | STE_106XC | 106
CXF334224 | 8560MFP | 721 Barton Springs | Finance 5th Floor | 574
CXF334273 | 8560MFP | [NAME] | DKR_STEELYDXC | office
FKA616117 | WC7345 | [NAME] | CICWASKOM | 200
GAL100277 | 3200MFP | St. Elmo | STE_TREE TREAMING_3B | 3B
[NAME] | WCP 4150 | [NAME] | DKR_TRAINX | BLDG. 6
L99034829 | WCP 4150 | 811 Barton Springs | CIS Operations RM 802 | 200
L99037714 | WC4150 | Kramer C | KRME_ANXX | ANX.
L99041449 | WCP 4150 | DOMAIN | DOM_4150X | office
LBP241998 | 3635MFP | Sand hill | SHEC_TRL_X | Trl.
LBP242161 | 3635MFP | One Texas Center | OTC_175_X | 175
LBP244209 | 3635MFP | Decker | Purchasing | [NAME]
LBP244351 | 3635MFP | 721 Barton Springs | 4th floor | 409
MDH000819G | 510 | 811 Barton Springs | [NAME] 601 | 601
[NAME] | 510 | St. Elmo | STE_102XP | 102
RYU331075 | M20i | [NAME] | HOL_CONTRMX | [NAME]
RYU331103 | M20i | [NAME] | DKR_WHSEX | Office
RYU331116 | M20i | Kramer D | KRMD_312X | 312
RYU331120 | M20i | St. Elmo | STE_NETWORK_1 | 1A
[NAME] | M20i | Holly Maint Shop | HOL_MAINTSHP | Maint Shop
RYU331127 | M20i | 906 [NAME] | JUSTIN_XEROX1 | Office
RYU331128 | M20i | St. Elmo | STE_206X | 206
RYU331572 | M20i | St. Elmo | [NAME] | 2A
RYU331589 | M20i | Kramer D | [NAME] | 1
RYU331590 | M20i | 811 Barton Springs | Processing RM305 | 305
RYU331592 | M20i | St. Elmo | STE_ADMINISTRATION_LOBBY_100X | Admin.
RYU331594 | M20i | [NAME] | DKR_TRIBLABX | Lab
TFN049829 | WCP3545 | 811 Barton Springs | Power Production | 607
TFN196336 | WCP 2636 | St. Elmo | STE_ADMINISTRATION_102 | 102
TFN196337 | WCP 2636 | [NAME] | SHEC_ADMINXC | File
TFN196338 | WCP 2636 | ECC RM249 | WST_249XC | 249
TFN196375 | WCP 2636 | Kramer C | KRMC_BRKRMXC | Brkrm
TFN196408 | WCP 2636 | Holly Lab B | HOLLYLAB_BXC | St. Off
TFN196607 | WCP 2636 | Kramer C | KRMC_200XC | 200
TFN196615 | WCP 2636 | [NAME] X | HOLLYADMINXC | 106
TFN196616 | WCP 2636 | DOMAIN | DOM_CNTLRMXC | [NAME]
TFN196635 | WCP2636 | St. Elmo | STE_ADMINISTRATION_212 | 212
TFN196637 | WCP 2636 | Kramer E | KRME_2120XC_METERING SHOP | 2120
TFN196649 | WCP 2636 | Kramer C | KRMC_100XC_ADMIN | 100
TFN196684 | WCP 2636 | Kramer E | KRME_222XC | 222
TFN196691 | WCP 2636 | ECC RM 109 | WST_109XC | 116
TFN196700 | WCP 2636 | ECC RM 043 | WST_043XC | 43
TFN196858 | WCP 2636 | [NAME] | CAM_XEROX1 | 121
TFN196878 | WCP 2636 | Kramer E | KRME_229XC | 229
TFN201872 | WCP3545 | [NAME] | CICWATERLOO | 300
TFN690555 | WCP2636 | 721 Barton Springs | Administration RM 575 | 575
TFN691868 | WCP2636 | 721 Barton Springs | Legal RM 506 | 506
TFN691935 | WCP2636 | 721 Barton Springs | Market Research RM 238 | 238
TFN691936 | WCP2636 | 721 Barton Springs | Customer Care RM 306 | 306
[NAME] | WCP2636 | 721 Barton Springs | Power Production RM 243 | 243
TFN692140 | WCP2636 | 721 Barton Springs | IT DDAS RM 429 | 429
TFN692455 | WCP 2636 | [NAME] | MON_LDOCK_XC | load dock office
TFN692458 | WCP2636 | 811 Barton Springs | Corp Consultant [NAME] 230 | 230
TFN692459 | WCP2636 | 811 Barton Springs | Energy Efficiency Svcs RM 310 | 310
TFN692460 | WCP2636 | 721 Barton Springs | [NAME] | 460
TFN692697 | WCP2636 | 721 Barton Springs | Human Relations RM 125 | 125
TFN692709 | WCP2636 | 721 Barton Springs | Public Involvement RM102 | 102
TFN692798 | WCP2636 | 811 Barton Springs | 2nd [NAME] | 215
TFN699402 | WCP2636 | 721 Barton Springs | Energy Marketing RM 208 | 208
TFN699414 | WCP2636 | 721 Barton Springs | Finance RM 575 | 556
TFN699937 | WCP2636 | 721 Barton Springs | Key Account/ Commercial RM 331 | 331
TFN700114 | WCP 3545 | Kramer E | KRME_108XC_ADMIN | 108
URT102223 | WCP 232 | Crossdocks | Crossdock_X | 100
URT103867 | WCP232 | 721 Barton Springs | ITT RM 453 | 453
URT103900 | WCP 232 | [NAME] | CAM_XEROX2 | 114C
URT103907 | WCP232 | 721 Barton Springs | 2nd Flr File Rm RM 223 | 223
URT103922 | WCP232 | 721 Barton Springs | 2nd Floor | 260
URT103930 | WCP232 | 721 Barton Springs | 5th Floor General Managers Off | 520
URT103943 | WCP232 | 721 Barton Springs | ITT RM 432 | 432
URT103950 | WCP232 | 721 Barton Springs | Purchasing RM 404 | 404
URT103955 | WCP232 | 721 Barton Springs | Key Account/ Commercial RM 337 | 337
URT103956 | WCP232 | 811 Barton Springs | Green Building Program RM300 | 300
URT103961 | WCP232 | 721 Barton Springs | Customer Care RM 314 | 314
[NAME] | WCP232 | 721 Barton Springs | Finance RM 400 | 400.12
URT104015 | WCP 232 | [NAME] | CAM_XEROX3 | 115
URT104022 | WCP232 | 721 Barton Springs | Finance RM 545 | 545
URT104025 | WCP232 | 721 Barton Springs | Credit/Collections RM 348 | 348
URT104054 | WCP232 | 811 Barton Springs | Energy Efficiency Svcs RM 310 | 310
URT104057 | WCP232 | 721 Barton Springs | Power Production RM 275 | 275
URT104061 | WCP232 | 721 Barton Springs | Purchasing RM 410 | 410
[NAME] | WCP232 | 721 Barton Springs | Payment Processing  RM 243 | 129
URT104082 | WCP232 | 811 Barton Springs | [NAME] | 305b
URT104125 | WCP 232 | Holly Lab E | HOLLYLAB_EX | 102
URT809963 | WCP 232 | Kramer D | KRMD_002X | 2
URT810028 | WCP 232 | St. Elmo | STE_ADMINISTRATION_205 | 205
URT810070 | WCP 232 | St. Elmo | STE_WHSE1X | Whse
URT951428 | WCP232 | 721 Barton Springs | Service Orders/Billing RM349 | 349
URT951462 | WCP232 | 721 Barton Springs | Cust Svc Management RM 323 | 323
URT952655 | WCP232 | 811 Barton Springs | Energy Efficiency Svcs RM 311 | 311
URT955238 | WCP232 | 811 Barton Springs | Energy Efficiency Svcs RM 317 | 317
URT963141 | WCP232 | 811 Barton Springs | Marketing Communications RM 250 | 250
UTU104309 | WCP275 | 721 Barton Springs | Human Relations RM 108 | 108
UTU105163 | WCP232 | 811 Barton Springs | Energy Efficiency Svcs RM 302 | 302
UTV851888 | WCP 255 | St. Elmo | STE_ADMINISTRATION_101 | 101
VDR002448 | WC7655 | 721 Barton Springs | TLC_250XC | 250
VDR002764 | WC7655 | 811 Barton Springs | 811_100XC | 100
VDR003309 | WC7655 | Nmopac RM 425B | NMOPAC_425XC | 425B
VDR003399 | WC7655 | Nmopac RM 425C | MOPC_425XC | 425C
VDR545541 | WC7655 | Decker | DKR_ADMIN | Admin.
VDR555935 | WC7655 | 811 Barton Springs | 811_807XC | 807
VDR556100 | WC7655 | 811 Barton Springs | 811_805XC | 805
VDR556109 | WC7655 | 721 Barton Springs | 5th Floor | 530
[NAME] | WC7655 | 811 Barton Springs | 811_810XC | 810
VGW619389 | DC240 | 811 Barton Springs | Marketing Communications RM 250 | 250
WTD004630 | WC5645 | Nmopac RM425B | MOPB_425X | 425B