Locating "Z" value with respect to "X" &"Y" values in a excel table.

Hello, In a project I have this excel table, in which I have the first row as X values and first column as Y values. Now all the other values in relation with corresponding X and Y values are present. All I need is to 1) Search the table if my Calculated X and Y values lie in table. 2) If present then find corresponding "Z" value. 3) To do interpolation if necessary

If anyone could help, I would be very thankful. Tks

<<C---Users--YASIR--Desktop--Untitled.png>>

Answer 1

[Matt J]

You may as well skip (1) and (2). Interpolation will trivially return the given Z(i,j) values if you query at one of the given (X(i),Y(j))

Read your data into a 2D Z matrix using xlsread. Similarly, read in your X and Y as vectors. Then do

F=griddedInterpolant(X,Y,Z);

Now query at points Xq, Yq as follows

out=F(Xq,Yq);

[am]

Thanks bro!