Vlookup several criteria

[B&L]

Hi !

I am looking for a formula, probably a vlookup that would find a value corresponding to two criteria.

The formula that I though would work is:

=VLOOKUP(A3&$B$2;CHOOSE({1;2};F14:F34&G14:G34;I14:I34);2;0)

It is supposed to find back the value that would correspond to the date and the segment.

Is there anything wrong in my formula already?

[Tony Valko]

Try this array formula**:

=INDEX(I14:I34;MATCH(1;(F14:F34=A3)*(G14:G34=B2);0))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

[RedSummer]

I just made this for myself from a recent post I just saw, might find it useful.


This spreadsheet Multi Condition Table lookup.xlsx has the four options from this other thread from a few hours ago.

I personally prefer the Array formula because its syntax makes the most sense to me.

Red