All Forums  Origin Forum  Origin Forum  Dynamic Column References Across Workbooks

Note: Only the poster of this message, and the Moderator can edit the message.

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Forum: Origin Forum Subject: Message: * HTML is OFF * Forum Code is ON Smilies Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 2022b (64-bit) SR1 9.9.5.171 (Academic) Operating System: Windows 11 Home Hello, I have two workbooks. The first contains 19 pairs of columns. In the second I want to output the data in the first column of each pair at the index of the maximum value of the second column. I want each row of the second workbook to correspond to a different pair of columns. I have created the following formula to try to achieve this. =table([Book1]Sheet1!(2i),[Book1]Sheet1!(2i-1),max([Book1]Sheet1!(2i)),0) However, it seems I cannot put an expression inside the column reference to reference the i-th column where i is the current row index. How can I dynamically reference columns like this, or what is a better way to do this? Thank you, Brandon   Check here to subscribe to this topic.