Reverse vLookup function

[rosasellen12]

Suppose the given is like a Cartesian plane where the x-axis is horizontal while the y-axis is vertical. Then, there are numbers labeled that can be used to dictate the correct coordinates of the cell or two (coordinates are within the line and not the cell; two cells mean that the number is whole, while a cell has 0.5). Therefore, how is it possible to label the (x,y) coordinates if there are cells in place to indicate the "appoximate" coorindates within the lines. (note: bonus points if excel can detect the coorinates of a 2by2 cell centroid........since it is not possible to label the center of the 2by2 cells)

Here is an example of the "Catesian" plane:

0​	1​	2​	3​	4​	5​	6​	7​	8​
1​
2​					A	A
3​
4​
5​			B					C
6​			B
7​						D	D
8​						D	D
9​
10​
			x	y
		A	5​	1.5​
		B	2.5​	5​
		C	7.5​	4.5​
		D	6​	7​

*the problem seems like the opposite of the vlookup that is why I put the title as it is
Thanks for any help, really appreaciate it!

 

[Legacy 143009]

It is a bit complicated for me so I have a complicated solution

Assuming 0 point is A1.
x:

=INDEX($A$1:$I$1,MIN(IF($A$1:$I$11="A",COLUMN($A$1:$I$11))))-(1-(COUNTIF(INDEX($A$1:$I$11,MIN(IF($A$1:$I$11="A",ROW($A$1:$I$11))),0),"A")*0.5))

y:

=INDEX($A$1:$A$11,MIN(IF($A$1:$I$11="A",ROW($A$1:$I$11))))-(1-(COUNTIF(INDEX($A$1:$I$11,0,MIN(IF($A$1:$I$11="A",COLUMN($A$1:$I$11)))),"A")*0.5))

Note that these are array formulas. Pasting only is not enough. You must paste and press Ctrl+Shift+Enter together.