how to get value from a table satisfying two conditions

[Dhirendra Kumar]

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

 

[Jacob Skaria]

With data as below try

=VLOOKUP("c",A15,MATCH(2,A11,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

 

[Excel_Learner]

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.