You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

9 points

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

Posted on May 16, 2022 7:41 PM

Top-ranking reply

Level 8

36,122 points

Posted on May 16, 2022 8:24 PM

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)

View in context

Similar questions