vlookup 2 values

  • Thread starter Thread starter melawaisi
  • Start date Start date
M

melawaisi

hi,

I would like to take a value from a table, where i have 2
restrictions.

the equation below i am using, and it works fine for one lookup, but i
would like to compare with 2 values!!!

table 2 has 3 columns, and table 1 has 5 columns, i would like to
lookup in table 2 for 2 values, x and y, so both x ,and y should match
that of table 1

=VLOOKUP(G11,C74:E77,3)

I hope i have made the question understandable
 
melawaisi said:
hi,

I would like to take a value from a table, where i have 2
restrictions.

the equation below i am using, and it works fine for one lookup, but i
would like to compare with 2 values!!!

table 2 has 3 columns, and table 1 has 5 columns, i would like to
lookup in table 2 for 2 values, x and y, so both x ,and y should match
that of table 1

=VLOOKUP(G11,C74:E77,3)

I hope i have made the question understandable
Click to expand...

Your explanation isn't awfully clear, but this may be something like you
want.
=INDEX($E$74:$E$77,MATCH(1,($C$74:$C$77=G11)*($D$74:$D$77=H11),0))
It looks up G11 in C74:C77 and H11 in D74:D77, returning the value from
column E corresponding to the first double match found. It is an array
formula, so has to be entered using CTRL+SHIFT+ENTER rather than just ENTER.
 
Back
Top