Hi! I want to use a formula connecting two different spreadsheets. Im trying to use VLOOKUP formula, when I try to select for the table array, a table in another file inside workiva, the formula is no longer active and I cant continue typing. Is there a way to make a reference in the formula to a table that is in another document?
You are not able to use a formula to reference a different Workiva file. However, you can link the data into the document and then use a formula to reference the destinations.
Please let us know if you have any additional questions.
Please sign in to leave a comment.