Skip to main content
I
IRarch1-Visitor
1-Visitor
August 23, 2017
Question

Matching values in a row of a table

  • August 23, 2017
  • 21 replies
  • 9337 views

Hi,

 

I have an extensive table with 5 columns (0 to 4) and more than 1000 rows!

I want to select the values from dorp down lists for the first 4 variables (each variable in one of the first 4 columns). Then I want to find the row that contains all the exact values I selected previously so to find the value of the 5th column (4) at that row (the row with the exact values). No row in the entire table repeats.

 

Attached is the table in an excel file I will be using.

 

I would like to be able to select the Height, Width, HFX Condition, Bolt Diameter and then get the corresponding Seismic Allowable Shear value.

 

 

Any ideas? Thanks!

21 replies

W
Werner_E25-Diamond I
25-Diamond I
August 23, 2017

What you are looking for should be able to do with a routine from Richards fine collection of scriptable components (which I can't find now in this new, horribly forum) using Mathcad 15, bur not with Prime.

Your list includes a lot of duplicates concerbning the first four columns and the bolt diameter it "1.125 STD" throughout.

So which result do you expects with Height=78, Width=9, HFX Cond = Concrete 2500psi and bolt d. =1.125 ?

Bild.png

I
IRarch1-VisitorAuthor
1-Visitor
August 23, 2017

Hi @Werner_E,

 

You are right, I forgot to add one more column. Plese see revised file. The table is much more complex but I was trying to simplify it. The idea is that no row repeats in a table of 1000+ rows.

 

I'll appreciate if you do find the routine or if you can send me on the right direction.

 

Thanks!

R
RichardJ19-Tanzanite
19-Tanzanite
August 24, 2017

Does this not do what you want?

R
RichardJ19-Tanzanite
19-Tanzanite
August 23, 2017

Like this?

Terms & ConditionsAccessibility statement