'Get Cell Value From Another Sheet USING ADDRESS and MATCH

I have here a condition/function. I'm not really experienced in Google Sheets.

=ADDRESS(MATCH(B32,Diana!B:B,0),1)

Now, Diana is another worksheet. The result from the function above is $A$2. I want to get the result or the cell value of Diana!A2. How should I make that happen??

google-sheets spreadsheet

Solution 1:^[1]

try:

=INDIRECT("Diana!"&ADDRESS(MATCH(B32, Diana!B:B, 0), 1))

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	player0

'Get Cell Value From Another Sheet USING ADDRESS and MATCH

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]