Spreadsheet: 697542d1601397708-vlookup-query-for-different-sheet-involving-indirect-substitute-address-example
Sheet: Fund Prices

Fund name | fund1 |  |  | fund2 |  |  | fund3 |  |  | fund4 |  |  | [NAME] |  |  | fund6 |  |  | fund7 |  |  | fund8
 | 2020-09-25 00:00:00 | 261 |  | 2020-09-25 00:00:00 | 261.7 |  | 2020-09-25 00:00:00 | 238.8 |  | 2020-09-25 00:00:00 | 185.6 |  | 2020-09-25 00:00:00 | 232.9 |  | 2020-09-25 00:00:00 | 879.2 |  | 2020-09-25 00:00:00 | 209.3 |  | 2020-09-25 00:00:00 | 323.4
 | 2020-09-24 00:00:00 | 261.6 |  | 2020-09-24 00:00:00 | 260.3 |  | 2020-09-24 00:00:00 | 237.2 |  | 2020-09-24 00:00:00 | 188.8 |  | 2020-09-24 00:00:00 | 235 |  | 2020-09-24 00:00:00 | 877.4 |  | 2020-09-24 00:00:00 | 209.1 |  | 2020-09-24 00:00:00 | 323.3
 | 2020-09-23 00:00:00 | 267.9 |  | 2020-09-23 00:00:00 | 260.7 |  | 2020-09-23 00:00:00 | 239.7 |  | 2020-09-23 00:00:00 | 190.3 |  | 2020-09-23 00:00:00 | 239.8 |  | 2020-09-23 00:00:00 | 895.6 |  | 2020-09-23 00:00:00 | 208.2 |  | 2020-09-23 00:00:00 | 324.7
 | 2020-09-22 00:00:00 | 263.3 |  | 2020-09-22 00:00:00 | 262.1 |  | 2020-09-22 00:00:00 | 239 |  | 2020-09-22 00:00:00 | 187.2 |  | 2020-09-22 00:00:00 | 236 |  | 2020-09-22 00:00:00 | 884.8 |  | 2020-09-22 00:00:00 | 209.9 |  | 2020-09-22 00:00:00 | 322.8
 | 2020-09-21 00:00:00 | 262.9 |  | 2020-09-21 00:00:00 | 263.1 |  | 2020-09-21 00:00:00 | 240.4 |  | 2020-09-21 00:00:00 | 187.1 |  | 2020-09-21 00:00:00 | 235.4 |  | 2020-09-21 00:00:00 | 880.9 |  | 2020-09-21 00:00:00 | 210.4 |  | 2020-09-21 00:00:00 | 326.5
 | 2020-09-20 00:00:00 | 266.7 |  | 2020-09-20 00:00:00 | 262.1 |  | 2020-09-20 00:00:00 | 241 |  | 2020-09-20 00:00:00 | 193.3 |  | 2020-09-20 00:00:00 | 242.3 |  | 2020-09-20 00:00:00 | 888.5 |  | 2020-09-20 00:00:00 | 208.8 |  | 2020-09-20 00:00:00 | 323
 | 2020-09-19 00:00:00 | 266.7 |  | 2020-09-19 00:00:00 | 262.1 |  | 2020-09-19 00:00:00 | 241 |  | 2020-09-19 00:00:00 | 193.3 |  | 2020-09-19 00:00:00 | 242.3 |  | 2020-09-19 00:00:00 | 888.5 |  | 2020-09-19 00:00:00 | 208.8 |  | 2020-09-19 00:00:00 | 323
 | 2020-09-18 00:00:00 | 266.7 |  | 2020-09-18 00:00:00 | 262.1 |  | 2020-09-18 00:00:00 | 241 |  | 2020-09-18 00:00:00 | 193.3 |  | 2020-09-18 00:00:00 | 242.3 |  | 2020-09-18 00:00:00 | 888.5 |  | 2020-09-18 00:00:00 | 208.8 |  | 2020-09-18 00:00:00 | 323
 | 2020-09-17 00:00:00 | 266.5 |  | 2020-09-17 00:00:00 | 260.3 |  | 2020-09-17 00:00:00 | 239.8 |  | 2020-09-17 00:00:00 | 193.3 |  | 2020-09-17 00:00:00 | 241.6 |  | 2020-09-17 00:00:00 | 893 |  | 2020-09-17 00:00:00 | 209.5 |  | 2020-09-17 00:00:00 | 322.7
 | 2020-09-16 00:00:00 | 270.9 |  | 2020-09-16 00:00:00 | 261.5 |  | 2020-09-16 00:00:00 | 240.6 |  | 2020-09-16 00:00:00 | 195.3 |  | 2020-09-16 00:00:00 | 245.2 |  | 2020-09-16 00:00:00 | 909.1 |  | 2020-09-16 00:00:00 | 209.7 |  | 2020-09-16 00:00:00 | 324.8
 | 2020-09-15 00:00:00 | 270.9 |  | 2020-09-15 00:00:00 | 259.9 |  | 2020-09-15 00:00:00 | 241.7 |  | 2020-09-15 00:00:00 | 196.3 |  | 2020-09-15 00:00:00 | 244.1 |  | 2020-09-15 00:00:00 | 898.7 |  | 2020-09-15 00:00:00 | 209.6 |  | 2020-09-15 00:00:00 | 324.1
 | 2020-09-14 00:00:00 | 269 |  | 2020-09-14 00:00:00 | 261.9 |  | 2020-09-14 00:00:00 | 243.8 |  | 2020-09-14 00:00:00 | 193.1 |  | 2020-09-14 00:00:00 | 241.9 |  | 2020-09-14 00:00:00 | 893.6 |  | 2020-09-14 00:00:00 | 210 |  | 2020-09-14 00:00:00 | 323.6
 | 2020-09-13 00:00:00 | 268.1 |  | 2020-09-13 00:00:00 | 259.1 |  | 2020-09-13 00:00:00 | 240.8 |  | 2020-09-13 00:00:00 | 192.9 |  | 2020-09-13 00:00:00 | 240 |  | 2020-09-13 00:00:00 | 886.1 |  | 2020-09-13 00:00:00 | 209.4 |  | 2020-09-13 00:00:00 | 323.6
 | 2020-09-12 00:00:00 | 268.1 |  | 2020-09-12 00:00:00 | 259.1 |  | 2020-09-12 00:00:00 | 240.8 |  | 2020-09-12 00:00:00 | 192.9 |  | 2020-09-12 00:00:00 | 240 |  | 2020-09-12 00:00:00 | 886.1 |  | 2020-09-12 00:00:00 | 209.4 |  | 2020-09-12 00:00:00 | 323.6
 | 2020-09-11 00:00:00 | 268.1 |  | 2020-09-11 00:00:00 | 259.1 |  | 2020-09-11 00:00:00 | 240.8 |  | 2020-09-11 00:00:00 | 192.9 |  | 2020-09-11 00:00:00 | 240 |  | 2020-09-11 00:00:00 | 886.1 |  | 2020-09-11 00:00:00 | 209.4 |  | 2020-09-11 00:00:00 | 323.6