Search the Community
Showing results for tags 'vlookup'.
Found 2 results
Dynamic block that scales based on user input?
eyeofnewt555 posted a topic in AutoCAD Drawing Management & OutputHey guys! So at my office we frequently have to show circles around objects. The circle's size is based on a multiplier that will vary with project and the diameter of the object. This is super easy math that could be done on the fly when creating a circle. BUT, I'd like to streamline it just a wee bit and make a simple block of the circle that allows for the following user input in the properties panel: Reference object diameter (Dro): [user types here] Multiplier (M): [comes with preset value, but user can override here] And then the linear parameter controlling the circle scaling will auto adjust to reflect: Diameter of Circle (Dc): D*M I've dabbled in Vlookup tables/fields/attributes but still on super shaky ground. Any guidance would be appreciated. Thanks!
VLOOKUP betwen AutoCAD and Excel?
alcatel posted a topic in AutoCAD 2D Drafting, Object Properties & InterfaceDoes anyone know how to achieve this? I have a series of blocks with attributes in Autocad. Attribute is a number (from 1 to 500). Each of the blocks represents a single machine with serial number 1-500 on it. When I place a new block of machine (I do it by copy/paste from the nearby block) I just change the attribute value manually. Now, as a separate file I have excel sheet with two columns: COLUMN A -> serial number of machines (1-500) COLUMN B -> type of machine (e.g. TYPE-1, TYPE-2, TYPE-3...), around 8 types in total Is it possible to make a block with two values in it (attributes) and when a value of machine serial number in position 1 is changed it will look the excel file and return the machine type in position 2. Something like VLOOKUP excel formula, but in AUTOCAD. For example if EXCEL is: COLUMN A / COLUMN B 250 / TYPE-3 251 / TYPE-5 Than the change in AutoCAD attributes in position 1 and 2 is like this: ATT-1: 250 ATT-2: TYPE-3 if I manually change ATT-1 to value 251, then: ATT-1: 251 ATT-2: TYPE-3