Also, vice versa, how to create a formula in Cell F7 and enter any numbers from range B6:D8 and automatically display the corresponding (x,y) coordinates in Cell F8?

Please note: Using MS Office 365. The (x,y) coordinates in range B2:D4 corresponds to the numbers in range B6:D8

I just made it 3x3 to make it easier

to understand what I needed to be done. Thanks!

Please view the following data:

Range B2:D4

[1,1] [0,1] [1,1] Example: x, y coordinates

[-1,0] [0,0] [1,0] Cell F3 →[0,1] ENTER X,Y

[-1,-1] [0,-1] [1,-1]Cell F4 →[7] RESULTS

Range B6:D8

[5] [7] [6] Example: numbers

[8] [2] [3] Cell F7 →[0] ENTER #

[0] [1] [7] Cell F8 →[-1,-1] RESULTS