how to get value from a table satisfying two conditions

  • Thread starter Thread starter Dhirendra Kumar
  • Start date Start date
D

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
 
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
 
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.
 
Back
Top