davestephsamem
New Member
- Joined
- Mar 3, 2012
- Messages
- 34
I'm trying to pull over data from another Google Sheets WorkBook using XLOOKUP and IMPORTRANGE but I am getting a formula parse error - and can't see why:
=xlookup(B2,IMPORTRANGE(https://docs.google.com/spreadsheet...6T7V0DAU-Jne-vtfwRMly23Ja0/edit#gid=946556981,"Maths!A:N"),IMPORTRANGE(https://docs.google.com/spreadsheet...6T7V0DAU-Jne-vtfwRMly23Ja0/edit#gid=946556981,"Maths!L:L"),0)
Thanks
=xlookup(B2,IMPORTRANGE(https://docs.google.com/spreadsheet...6T7V0DAU-Jne-vtfwRMly23Ja0/edit#gid=946556981,"Maths!A:N"),IMPORTRANGE(https://docs.google.com/spreadsheet...6T7V0DAU-Jne-vtfwRMly23Ja0/edit#gid=946556981,"Maths!L:L"),0)
Thanks