Ask Your Question
1

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

asked 2018-10-07 15:01:29 +0200

Lander123 gravatar image

updated 2018-10-08 13:54:36 +0200

Lupp gravatar image

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 flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
2

answered 2018-10-07 15:10:07 +0200

updated 2018-10-07 17:48:01 +0200

EasyTrieve gravatar image

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)

edit flag offensive delete link more
0

answered 2018-10-08 10:53:58 +0200

Lander123 gravatar image

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-10-07 15:01:29 +0200

Seen: 39 times

Last updated: Oct 08 '18