I had to create a workaround for something I think should be available in the Vectorworks Worksheets.
It does not seem that the Xlookup function (and others I presume?) can use a DB row for its search-array and result-array parameters, only for the search-value parameter. The workaround for this was copying and pasting the search/result DB subrows I want into spreadsheet cells and referencing that array in my Xlookup instead of the DB header it came from. This would be great for comparing data sets between records and objects and worksheets within a DB row's column.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
.png.682a1dde7889dd17fdb4e18ba0421cf6.png)
Question
kaj5021
I had to create a workaround for something I think should be available in the Vectorworks Worksheets.
It does not seem that the Xlookup function (and others I presume?) can use a DB row for its search-array and result-array parameters, only for the search-value parameter. The workaround for this was copying and pasting the search/result DB subrows I want into spreadsheet cells and referencing that array in my Xlookup instead of the DB header it came from. This would be great for comparing data sets between records and objects and worksheets within a DB row's column.
Link to comment
0 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.