Return a value in a table from the x & y 'co-ordinates'

Copper Contributor

I have an excel table (25x by 25y values)

I want to enter seperate x and y values then return the relevant value in the actual table.


Enter x value in one cell

Enter y value in another cell

Either: (ideally) Return x:y cell value

Or: move cursor to x:y cell

2 Replies
best response confirmed by Hans Vogelaar (MVP)



Does INDEX and MATCH return the intended result?

return value from table.png