Spreadsheet: 288955d1389359145-how-do-i-create-a-summary-sheet-looking-up-multipule-values-summary
Sheet: Consolodated data

Business | Floor | Room | Device Code | Asset number | Monitor | Mon 1 Asset number | Mon 2 Asset number
ARC | G | A010 | Z90 | 1166228 | 2 x 17 | 21086 | 57358
ARC | G | A010 | 790 | 1137792 | 19 | 13848 | n/a
ARC | G | A010 | 790 | 1138008 | 17 | 52377 | n/a
ARC | G | A010 | Z90 | 1164143 | 2 x 17 | 22724 | 57363
ARC | G | A010 | Z90 | 1166265 | 2 x 17 | 61592 | 61597
ARC | G | A010 | 790 | 1138655 | 17 | 20557 | n/a
ARC | G | A010 | 280 | 1110721 | 2 x 17 | 21126 | 57355
ARC | G | A010 | 790 | 1137816 | 2 x 19 | 35522 | 14007
ARC | G | A010 | E5520 | n/a | n/a | n/a | n/a
ARC | G | A010 | 790 | 1137810 | 2 x 17 | 57359 | 57360
ARC | G | A010 | Z90 | 1166094 | 2 x 17 | 35401 | 61542
ARC | G | A010 | 520 | 1118364 | 2 x 17 | 20586 | 20587
ARC | G | A010 | 520 | 1117448 | 2 x 17 | 19309 | 57356
ARC | G | A010 | 520 | 1122346 | 2 x 17 | 21088 | 17275
ARC | G | A010 | V30 | 1122728 | 17 | 22737 | n/a
ARC | G | A010 | V30 | 1116318 | 17 | 59824 | n/a
ARC | G | A010 | Z90 | 1166102 | 2 x 17 | 57365 | 57366
ARC | G | A010 | V30 | 1120809 | 17 | 18652 | n/a
KNL | G | B018 | HIPS Terminal | 1103265 | Not recorded | Not recorded | n/a
KNL | G | B018 | V30 | 1120835 | 17 | 20079 | n/a
KNL | G | B018 | V30 | 1127682 | 17 | 21925 | n/a
KNL | G | B018 | V30L | 1160240 | 17 | 21932 | n/a
KNL | G | B018 | V30 | 1122215 | 17 | 21977 | n/a
KNL | G | B018 | V30 | 1120078 | 17 | 31866 | n/a
KNL | G | B018 | V30L | 1134345 | 17 | 21926 | n/a
KNL | G | B018 | V30 | 1121938 | 17 | 27210 | n/a
KNL | G | B018 | V30 | 1121970 | 17 | 21692 | n/a
KNL | G | B018 | V30 | 1127684 | 17 | 21928 | n/a
KNL | G | B040 | 280 | Not Recorded | 17 | n/a | n/a
KNL | G | B040 | 280 | 1112542 | 17 | n/a | n/a
KNL | G | B040 | 280 | 1112544 | 17 | n/a | n/a
ARC | 1 | a110 | Z90 | 1166223 | 2 x 17 | 21031 | 61606
ARC | 1 | A110 | Z90 | 1164865 | 2 x 17 | 21169 | 61598
ARC | 1 | A110 | X90M7 | n/a | n/a | n/a | n/a
ARC | 1 | A110 | Z90 | 1164893 | 2 x 17 | 21039 | 61600
ARC | 1 | A110 | Z90 | 1166256 | 2 x 17 | 14292 | 56844
ARC | 1 | A110 | Z90 | 1166272 | 2 x 17 | 27206 | 61595
ARC | 1 | a113 | V30L | 1139446 | 17 | 22735 | n/a
ARC | 1 | a136 | 520 | 1117466 | 2 x 17 | Not recorded | Not recorded
ARC | 1 | a138 | 755 | 1132038 | 2 x 17 | 21178 | Not recorded
ARC | 1 | a142 | 755 | 1128715 | Not recorded | Not recorded | Not recorded
ARC | 1 | a142 | 780-NHS | 1133188 | 17 | Not recorded | n/a
ARC | 1 | a142 | 755 | 1128696 | 17 | 56988 | n/a
ARC | 1 | a142 | 520 | 1120174 | 17 | 31630 | n/a
ARC | 1 | b109 | V30L | 1134276 | 17 | 26588 | n/a
ARC | 1 | b109 | V30L | 1151430 | 19 | 35521 | n/a
ARC | 1 | b109 | V30L | 1134280 | 17 | 21989 | n/a
ARC | 1 | b110 | V30 | 1122738 | 17 | 19813 | n/a
ARC | 1 | b110 | 790 | 1138652 | 17 | 19748 | n/a
ARC | 1 | b123 | t643 | 1127053 | n/a | n/a | n/a
ARC | 1 | b125 | 790 | 1137801 | 17 | 25822 | n/a
KNL | 1 | a121 | T610 | Not recorded | n/a | n/a | n/a
KNL | 1 | c103 | 760 | Not recorded | n/a | n/a | n/a
KNL | 1 | c103 | V30LE | 1139511 | 17 | 21114 | n/a
KNL | 1 | c103 | V30LE | 1151691 | 17 | Not recorded | n/a
KNL | 1 | c103 | V30LE | 1151852 | 17 | 59820 | n/a
KNL | 1 | c103 | V30 | 1125291 | 17 | 56970 | n/a
ARC | 2 | b225 | V30L | 1139549 | 17 | 56879 | n/a
ARC | 2 | b225 | V30L | 1136533 | 17 | 56880 | n/a
ARC | 2 | b225 | V30L | 1139451 | 17 | 56881 | n/a
ARC | 2 | b225 | V30 | 1121846 | 17 | 56876 | n/a
ARC | 2 | b225 | 745 | 1132088 | 2 x 17 | 22178 | Not recorded
ARC | 2 | b225 | V30L | 1139492 | 17 | 56878 | n/a
ARC | 2 | b225 | V30LE | 1151654 | 17 | 56873 | n/a
ARC | 2 | b225 | E4300 | n/a | n/a | n/a | n/a
ARC | 2 | b228 | V30LE | 1156008 | 17 | 27959 | n/a
ARC | 2 | b228 | V30LE | 1151878 | 17 | 27988 | n/a
KNL | 2 | A210 | V30 | 1120821 | 17 | 28476 | n/a
KNL | 2 | A210 | V30 | 1118660 | 17 | 60863 | n/a
KNL | 2 | A210 | X90L | n/a | n/a | n/a | n/a
KNL | 2 | A210 | V30 | 1125891 | 17 | 24117 | n/a
KNL | 2 | A210 | V30 | 1120556 | 17 | 26234 | n/a
KNL | 2 | A210 | V30 | 1131687 | 17 | 34085 | n/a
KNL | 2 | A210 | 755 | 1133233 | 17 | 23675 | n/a
KNL | 2 | A210 | 270 | 1139578 | 17 | 56879 | n/a
KNL | 2 | A210 | V30L | 1139909 | 17 | 24360 | n/a
KNL | 2 | A210 | V30 | 1127680 | 17 | 15826 | n/a
KNL | 2 | A210 | V30 | 1117513 | 17 | 15922 | n/a
KNL | 2 | A210 | V30 | 1122141 | 17 | 17161 | n/a