jeudi 26 avril 2018

Excel multiple variable lookup then output a given value

I have two sheets in excel. The first sheet1 has 3 given values (E, fy, f'c), the second sheet2 has all of those same values with corresponding p (rho) values. I'm trying to write a code such as vlookup or similar that first checks for the fy column, then the f'c, then E, and then provides the p value at the intersection of those values. Any suggestions would be greatly appreciated.

Basically I should be able to input E = .0075, fy = 60000, f'c = 4000. Then the code should search Sheet2 and find the corresponding rho p value to be = .0138 (Column D, Row 16)

I've attached a google spreadsheet with the example. spreadsheet example

Aucun commentaire:

Enregistrer un commentaire