Return the value from specified coordinates from a grid

**Hitch75** · 07-15-2009, 12:02 PM

One more problem...

I already asked how to find coordinates, now it's the opposite.

I'm posting an example of a grid with coordinates, I need a formula which will tell which values are inside the cells with specified coordinates.
So, I need a formula in the yellow cells, the first result should be M, because at coordinates 0;1 there is an M.

Hope somebody can help again...
thanx!!

**NBVC** · 07-15-2009, 12:08 PM

Try:

=INDEX($H$5:$X$15,MATCH(AB5,$G$5:$G$15,0),MATCH(AA5,$H$4:$X$4,0))

copied down.

**Hitch75** · 07-15-2009, 01:00 PM

thanx a lot!!!

**NBVC** · 07-15-2009, 01:06 PM

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save