Jump to content
  • 5
tavbut

Lookup function in worksheets.

Question

Hello,

 

I've been trying to create a construction budget template that I can use in different projects and I need a lookup function for cell referencing.

Some time ago I tried to write a python script that could do this for me but I could not get the code to work because of some issues including my lack of knowledge in programing. Here's a link to the discussion about the script where I explain in more detail what this function should accomplish: 

In other spreadsheet programs I can use this function, in Excel there is the VLOOKUP and HLOOKUP functions, in google sheets as well. I could export information from VW and do my budgeting in other apps but I would really like to do all inside VW.

 

  • Like 1

Share this post


Link to post

3 answers to this question

Recommended Posts

  • 0

This would be a great addition to VW.  

 

This needs to work in database subrows also. In fact it may be more important in databases as there is currently no way to access the data in a specific subrow cell directly. Since the order of subrows can be changed by the addition or deletion of objects in the drawing, it is even more important to be able to find (lookup) a value in a database and return the data in a different cell in the associated subrow.

  • Like 1

Share this post


Link to post
  • 0

@tavbut I'm looking at using a lookup as well and I was wondering if you had made any progress on this. My intent is to use this to look up rainfall intensity from an imported worksheet, similar challenge different applications.

Share this post


Link to post

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.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×
×
  • Create New...