# find value in matrix (in other words: find value based on 2 criteria)

Hi, i am trying to make excel Calc find a value in a table i have in the same spreadsheet, that matches 2 conditions. I am trying to make Calc return the "maximum load value" of musical instrument strings based on "diameter" and "type"

My table looks like this:

diameter |     type    |  max. load

0,7_____________1_____________x

0,75____________2_____________x

0,8_____________1_____________x


etc.

The data, consisting of "max load values" looks like this:

diameter |     type 1    |   type 2 | type 3

0,7_____________500____________600____750

0,75____________550____________660____820

0,8_____________600____________710____870


etc.

how do i find "x"?

edit retag close merge delete

Sort by » oldest newest most voted

If you have your data like this:

Sheet1

    A       B       C
1   0,7     1       <Formula>
2   0,75    2       <Formula>
3   0,8     1       <Formula>


Sheet2

    A       B       C       D
1   0,7     500     600     750
2   0,75    550     660     820
3   0,8     600     710     870


... then you can use this formula in Sheet1.C1: =VLOOKUP(A1;$Sheet2.$A$1:$D\$3;B1+1;0)

more

this works !

The index part of vlookup function is what i could not seem to figure out. So, thanks for the help !

kind regards, Lander

more