Lookup Row and Column to make table

Hello All,

I think this could be a simple one for someone out there.

I'm looking for a formula that will return a value, dependant on matching both a column header and row header. I've attached an example spreadsheet that simplifies my data set. I currently have 3 Columns (X dist, Y dist, and Velocity at each point). I want to insert the data that I have in 3 columns, into more of a chart form with Y across the columns, and X down the rows. I'm looking for a formula that can be copied to the area in the chart to tell the cell to look up its corresponding header and row and return the value.

I'll eventually be using this table to create a 3D column chart with the depth axis being Y.

Excel Sample.xlsx

I look forward to giving rep to the first person that helps me out with this one.

All the best,
D

Thanks for the reply.
I've taken the formula you posted and tried to apply it to my actual spreadsheet (please find attached).

It doesn't seem to be working. Maybe this has something to do with the fact that the master data is actually a filtered table?

Have you any idea how to solve this? I'm after 'Point 2' across the top, and 'Point 1' down the rows, with the corresponding TI values in the middle of the table.

Kind regards,
D

EXAMPLE_HELP!.zip