Lookup Help!!

cdoc83

New Member
Joined
Oct 1, 2012
Messages
4
Hi all, I really hope you can help. I have the following spreadsheet that I wish to look up specific values.
</pre>
The raw data is below. For example I want to look up 1.5 Hs and 60deg Direction and return the value for X, Y and Z. Cheers in advance for any help.
</pre>
Stern SeasPort SeasBow SeasStarboard Seas
Direction0306090120150180210240270300330All
XYZXYZXYZXYZXYZXYZXYZXYZXYZXYZXYZXYZXYZ
Hs0.50.010.001.010.010.021.020.010.041.020.000.041.050.010.041.030.010.031.020.010.001.010.010.031.020.010.041.030.000.041.050.010.041.020.000.021.010.010.041.05
10.010.001.030.010.051.030.010.081.040.010.091.090.020.081.050.010.051.030.010.001.030.010.051.030.020.081.050.010.081.100.010.071.040.010.041.030.020.091.10
1.50.020.001.040.020.071.050.020.121.070.010.131.140.030.131.080.020.081.050.020.001.040.020.081.050.030.121.080.010.121.150.020.111.070.010.071.040.030.131.15
20.020.001.060.020.091.060.030.161.090.010.181.190.040.171.100.030.101.060.030.001.060.030.101.060.040.161.100.010.161.200.030.141.090.020.091.050.040.181.20
30.030.001.090.040.141.100.040.241.130.020.271.280.060.261.150.040.161.100.040.001.090.040.151.090.060.231.150.020.241.300.040.211.130.030.131.080.060.271.30
40.040.001.110.050.201.130.050.321.180.020.371.380.070.351.210.050.211.130.050.001.120.050.191.120.070.301.210.020.321.400.050.281.180.040.161.110.070.371.40
50.050.001.140.060.251.160.070.411.220.030.471.470.090.441.260.070.271.160.060.001.140.070.241.160.090.371.260.030.391.500.070.341.220.050.201.140.090.471.50
60.060.001.170.070.311.190.080.501.260.030.571.560.110.531.310.080.331.190.070.001.180.080.281.190.110.441.310.030.461.560.080.401.260.060.231.160.110.571.56
70.070.001.200.090.361.230.090.591.310.040.671.660.120.621.360.090.391.220.090.001.210.090.321.220.120.511.320.040.531.660.090.451.310.070.271.190.120.671.66
80.080.001.230.100.421.260.100.681.360.010.761.530.110.721.410.110.451.230.100.001.200.110.361.230.110.581.360.010.591.490.100.501.350.080.301.220.110.761.53
90.080.001.260.110.481.290.120.771.440.030.861.840.160.811.450.120.511.280.110.001.280.120.401.280.160.651.410.030.661.840.120.551.390.090.331.250.160.861.84
100.100.001.280.120.541.320.170.851.490.040.961.940.210.891.510.140.561.310.120.001.310.140.441.320.210.711.470.040.721.940.170.601.440.110.371.280.210.961.94

<colgroup><col><col><col span="8"><col><col span="30"></colgroup><tbody>
</tbody>
</pre>
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

DILIPandey

Well-known Member
Joined
Jul 25, 2013
Messages
1,336
It can be done using Index, Match nesting. Can you share the column name , row number from where you data starts ?


Regards,
DILIPandey
 

cdoc83

New Member
Joined
Oct 1, 2012
Messages
4
It can be done using Index, Match nesting. Can you share the column name , row number from where you data starts ?


Regards,
DILIPandey

Hi thank you for your reply.

The cell references are as follows - 0.5 is in cell C7, 1 is in cell C8 and so on.

I have tried to attach the sheet but not sure how to do it.

Thanks again.
 

DILIPandey

Well-known Member
Joined
Jul 25, 2013
Messages
1,336
Okay.. use below formula:-

=INDEX($C$5:$AP$17,MATCH($C$21,$C$5:$C$17,0),MATCH($D$21,$C$4:$AP$4,0)+COLUMN(A$1)-1)


Regards,
DILIPandey
 

Watch MrExcel Video

Forum statistics

Threads
1,114,098
Messages
5,545,951
Members
410,713
Latest member
TaremyLunsil
Top