vlookuop and double lookup_value? is it possible

[dmasvar]

Hi,

Witha vlookup we get to specify what the lookup value is, but is it possible to have two lokup value with the AND() addition to the formulae

eg. vlookup(and(1st value, 2nd value), ...etc

is tat possible..

\I've tried but failed...

iv'e got one criteria being ID, second being YR...

 

[Krishnakumar]

Hi,

Try something like..

=LOOKUP(2,1/((IDrange=ID)*(YRrange=YR)),ResultValueRange)

HTH

 

[Aladin Akyurek]

See:

http://www.mrexcel.com/board2/viewtopic.php?t=170029

for a less expensive approach.