vlookuop and double lookup_value? is it possible

dmasvar

New Member
Joined
Nov 17, 2004
Messages
33
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...
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Krishnakumar

Well-known Member
Joined
Feb 28, 2003
Messages
2,615
Hi,

Try something like..

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

HTH
 

Watch MrExcel Video

Forum statistics

Threads
1,118,670
Messages
5,573,558
Members
412,537
Latest member
Mohamed_5966
Top