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