I'm trying to create a custom formula that can effectively
vlookup the value in X cell against a column in another google sheets spreadsheet and return a value in the next column, the same row as the match. If I were querying in sheets directly I would simply use
=IMPORTRANGE but I am not sure how to emulate this in apps script?
I have found this article which shows how to perform the lookup using apps script in the current sheet but can't find out how to perform against another sheet.
Any help/advice gratefully received.