Jump to content
  • 5

Lookup function in worksheets.




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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


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.