how to search for a value in the nth column of a table

[Urchje]

Hi, I'm trying to make a formula that will search for value x in column y of table z. I'm stuck at the part of refering to column y.

[Sam Capricci]

without more information you could either use a vlookup or an hlookup. Other options also exist like index/match.

[Urchje]

Sorry, I did not make myself clear:

value = 0.6
column = 3
requested result formulae: 2 (second row of third column of table)

table:
0,1 0,2 0,1
0,3 0,5 0,6
0,8 0,7 0,9

[JohnTopley]

Try

=INDEX(ROW($A$1:$A$3),MATCH($D$1,INDEX($A$1:$C$3,,$E$1),0))

Table in A1:C3

D1=Value
E1=Column