PM1 said:Can you do a VLookup in Multiple sheets.
I have a sheet with a column of unique No's. I now want to look up that No in another sheet and report.
Master Asset File.xls | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | AssetNumber | LNnumber | SERIALNUMBERS | CostCentre | BPiDeptCode | Assetclass | SNo. | EvalNo. | Project | Cap.Date | Text | ||
2 | 1 | LN061888 | J0E5KYD32W | L99457 | L20002 | WindowsNTServers | S171A | 26/07/2004 | 292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB | ||||
3 | 2 | LN061889 | J0BTKYD32W | L99457 | L20002 | WindowsNTServers | S171A | 26/07/2004 | 292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB | ||||
4 | 3 | LN061890 | J0CXKYD32W | L99457 | L20002 | WindowsNTServers | S171A | 26/07/2004 | 292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB | ||||
5 | 4 | LN061891 | J0DDKYD32W | L99457 | L20002 | WindowsNTServers | S171A | 26/07/2004 | 292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB | ||||
6 | 5 | LN061892 | J0CUKYD32W | L99457 | L20002 | WindowsNTServers | S171A | 26/07/2004 | 292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB | ||||
7 | 6 | LN061893 | J0E1KYD32W | L99457 | L20002 | WindowsNTServers | S171A | 26/07/2004 | 292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB | ||||
8 | 7 | L99422 | L20012 | WindowsNTServers | S357A | 14/07/2004 | 325134-421ProLiantDL580(G2)R02Xeon | ||||||
9 | 8 | L99411 | L20004 | HardwareMaintenance | S289A | 15/07/2004 | FAS960C-IB-BASE2FAS960,CFO,IB,DATAONTAP | ||||||
10 | 9 | L99422 | L20012 | IBMServers | S229K | 30/07/2004 | 7038-6M2RackServer1:pSeries650Model6M2CEC | ||||||
11 | 10 | L99422 | L20012 | IBMServers | S229K | 30/07/2004 | 7038-6M2RackServer1:pSeries650Model6M2CEC | ||||||
12 | 11 | L99422 | L20012 | IBMServers | S229K | 30/07/2004 | 7038-6M2RackServer1:pSeries650Model6M2CEC | ||||||
13 | 12 | L99422 | L20012 | IBMServers | S229K | 30/07/2004 | 7038-6M2RackServer1:pSeries650Model6M2CEC | ||||||
14 | 13 | L99422 | L20012 | IBMServers | S229K | 30/07/2004 | 7311-D20I/ODrawer1:ModelD20I/ODrawer | ||||||
BP²I Assets |