apple numbers formula
I want to use two cells in table 1 to be found on table 2. For example:
I want to locate the cell in table 2 using table 1 A:2 & B:2. In this case I want the "Place" column in table 1 to show the C:2 value from table 2
Question marked as
Top-ranking reply
casey00000 wrote:
I want the "Place" column in table 1 to show the C:2 value from table 2
You can try something like this:
=INDEX(Table 2::$B$2:$H$7,MATCH(A2,Table 2::A,0),MATCH(B2,Table 2::$1:$1,0)−1)
Or, if your region uses , as a decimal separator:
=INDEX(Table 2::$B$2:$H$7;MATCH(A2;Table 2::A;0);MATCH(B2;Table 2::$1:$1;0)−1)
SG