With data as below try

=VLOOKUP("c",A1:D5,MATCH(2,A1:D1,0),0)

Col A Col B Col C Col D
1 2 3
a x x x
b x x x
c x x x
d x x x

--
Jacob


"Dhirendra Kumar" wrote:

I need assistance to get information from a table satisfying two varibles ie
if row and column values are given how to get the corresponding value from
the table? ie combination of Vlookup and Hlookup