Martin905

Thanks Letti. Works like a charm!

Hello. Just wondering if this was resolved as I'm trying to do something similar. Can VLOOKUP can be used with database rows? If not, is there an alternative method? I have two worksheets as shown below. I want the data rows of 'Housing Schedule':M2 to display the values in 'Parking Schedule':C2 based on common values of A2 in both. If a Plot value does not exist in 'Parking Schedule', then P.Prv. should display zero. I have tried various IF statements and experimented with VLOOKUP, but have had no joy. Thanks for any help!

Hi all, and thanks for your input. I actually solved this yesterday and tried to update here, but could not post as limited to one post per day! So sorry about that. For reference, the issue was 2-fold: 1. It doesn't seem to like nested symbols. My 'House-Type' is a symbol, which contains a 'label' symbol to which the record is attached. 2. The symbol seems to need some geometry. My 'label' symbol only contained text. Solution: I added an invisible polygon to the 'label' symbol. This solves '2' I then set my 'House-Type' symbols to 'convert to group' when placed. This solves '1'.

Thanks Pat. That makes sense. However, I've made sure the symbol insertion points are within the space, but still no joy. Could there be something else I'm missing? Or is there a different function for symbols?

Hello. Resurrecting an old thread as I am trying to achieve exactly this and cannot find any other reference online. Wondering if the OP ever had any joy? For context, my use case is as follows: I am setting up a template for housing scheme layouts, using Spaces as 'plots' and symbols (with attached records) for house types. I want to be able to schedule the houses to include the number of the plot (space) which they overlap with. Using "GetSpaceNameForObj" I am able to achieve this with simple polygons, but not with symbols (as illustrated in attached). Hoping there is a workaround, or an alternative method to achieve this? Thanks. (Using VW Design Suite 2025)