excel vba - vba loop through row and iterate -

i have set of data represents failure frequencies dependance on nominal pipe diameter.see table below.(in first row nominal diameters - dn , in 2nd 1 failure frequencies each dn)

50, 150, 300, 450, 600, 900

3.8e-05, 1.7e-05, 1.6e-05, 1.5e-05, 1.5e-05, 1.5e-05

what need loop through data , calculate appropriate failure frequency chosen dn (outside of table), let's dn 200.

any help? thanks

there 2 built in functions want - vlookup lookup value vertical list , hlookup lookup value horizontal list. lookup horizontal use hlookup.

the parameters follows:

=hlookup(value, table_array, row_index) 

where value value want lookup, table array range of lookup table , row_index row in table contains result.

if wanted value 200 , table @ d3 i4 , value lookup in row number 2 use following formula

=hlookup(200, d3:i4, 2)