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

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

If your data is as under:

Jan Feb Mar Apr
A ABC BAC CAB CBA
B BCD CBD DBC DCB
C CDA DCA ACD ADC
D DAB ADB BDA ABD

and you want to look data for "C" under "Feb" column then:

OFFSET(A2, MATCH("C", A3:A6, 0), MATCH("Feb", B2:E2, 0))

Reply if your query solved.



"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