Print Page | Close Window

Block Attribute with Lookup to Extract to Excel

Printed From: CAD Forum
Category: EN
Forum Name: AutoCAD
Forum Description: Discussion about AutoCAD and AutoCAD LT, viewers, DWG and DWF formats, Design Review, AutoCAD 360, add-ons
URL: https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13250
Printed Date: 31.May.2026 at 21:19


Topic: Block Attribute with Lookup to Extract to Excel
Posted By: Mark_Duffy
Subject: Block Attribute with Lookup to Extract to Excel
Date Posted: 02.Aug.2019 at 12:06

Good day to you all.

I am trying to find a way to have a drop-down lookup attached to an attribute in a block.

Electric switch, Type: one gang, Two gang, Three gang … etc

Or

Room: Living room, Kitchen, Bathroom… etc 

I can type these in as a type of room name in the Edit Attributes box but spelling mistakes or extra space / full stop will mean that it is in a separate column when Extract Data is performed. A drop down will avoid this. There are a number of instances with a switch where there are different options. So this would be a really useful ability for me and I’m hoping others. I have used look up with the stretch state on Linear for doors and windows and  

I have thought of having and invisible numbers which can be chosen but haven’t got my head around that yet and visibility states do not extract.

Here’s Trilled to look forward to getting a solution.

All the best

Mark




Print Page | Close Window