Spreadsheet: 700789d1603346290-complicated-look-up-with-spaces-in-search-table-complicated-look-up-from-table-with-spaces
Sheet: Sheet1

 |  | Formula in yellow coloured cells
 | Search criteria | Lease Name | DP Number | Outgoings Type | Rent Area | Location |  |  |  |  |  |  |  | Look UP table
 | 6009 |  |  |  |  |  |  |  |  |  |  |  |  | Legal Entity / Trading Name | Account Number / Site Code | Building / Land | Location | Rentable Area (m2) | Outgoings Type
 | 6008 |  |  |  |  |  |  |  |  |  |  |  |  | A.G. COOMBS (NSW) Pty Ltd | DP918225 |  | Depature | 48.81
 | 07072 |  |  |  |  |  |  |  |  |  |  |  |  | AG COOMBS | 628-2-628231 | SEAMLESS TRANSFER |  | 19.51 | Net
 | 31241 |  |  |  |  |  |  |  |  |  |  |  |  | AG COOMBS | 628-2-628245 | SEAMLESS TRANSFER |  | 29.3 | Net
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ADAPTALIFT GSE PTY LTD | DP918243 |  | [NAME] | 1328.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ADAPTALIFT | 07-AV-007072 | NE SECTOR |  | 1328.7 | Net
 | Desired answer below |  |  |  |  |  |  |  |  |  |  |  |  | AERO LOGISTICS PTY LIMITED | DP901000 |  | Land Side | 625.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06-HE-006010 | SE SECTOR |  | 115.7 | Net
 | Search criteria | Lease Name | DP Number | Outgoings Type | Rent Area | Location |  |  |  |  |  |  |  |  | 06-HE-006011 | SE SECTOR |  | 305 | Net
 | 6009 | AERO LOGISTICS PTY LIMITED | DP901000 | Net | 143 | Land Side |  |  |  |  |  |  |  |  | 06-HE-06008A | SE SECTOR |  | 62 | Net
 | 6008 | AERO LOGISTICS PTY LIMITED | DP901000 | Net | 62 | Landside |  |  |  |  |  |  |  |  | 06-HE-06009A | SE SECTOR |  | 143 | Net
 | 07072 | ADAPTALIFT GSE PTY LTD | DP918243 | Net | 1328.7 | [NAME] |  |  |  |  |  |  |  | AIR ASIA X | DP903545 |  | Aero | 39.8
 | 31241 | AIR CANADA | DP601000 | - | 48.34 | Common |  |  |  |  |  |  |  | AIR ASIA | T1-L3-031062 | TERMINAL 1 |  | 39.8 | Net
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AIR ASIA | T1-L3-031062 | TERMINAL 1 |  | 39.8 | Net
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AIR ASIA | T1-L3-031062 | TERMINAL 1 |  | 39.8 | Net
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AIR CALIN | DP600000 |  | Aero | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T1-L3-031328 | TERMINAL 1 |  | 30 | Net
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T1-L3-031328 | TERMINAL 1 |  | 30 | Net
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AIR CALIN | T1-L3-031328 | TERMINAL 1 |  | 30 | Net
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AIR CALIN | T1-L3-031328 | TERMINAL 1 |  | 30 | Net
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AIR CANADA | DP601000 |  | Common | 48.34
 | https://www.excelforum.com/showthread.php?t=1330626 |  |  |  |  |  |  |  |  |  |  |  |  |  | T1-L3-031241 | TERMINAL 1 |  | 48.34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T1-L3-031241 | TERMINAL 1 |  | 48.34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T1-L3-031241 | TERMINAL 1 |  | 48.34
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AIR CHINA | DP600900 |  | Airside | 111.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AIR CHINA | T1-L3-031309 | TERMINAL 1 |  | 111.3 | Net
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AIR CHINA | T1-L3-031309 | TERMINAL 1 |  | 111.3 | Net
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AIR CHINA | T1-L3-031309 | TERMINAL 1 |  | 111.3 | Net
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AIR INDIA | DP600100 |  | Airside | 46.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AIR INDIA | T1-L3-031237 | TERMINAL 1 |  | 46.8 | Net
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AIR INDIA | T1-L3-031237 | TERMINAL 1 |  | 46.8 | Net
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AIR INDIA | T1-L3-031237 | TERMINAL 1 |  | 46.8 | Net
 | 07018